NNM Node Status Codes (235 Views)
Reply
Super Advisor
Edward Fultz
Posts: 304
Registered: ‎03-13-2008
Message 1 of 2 (235 Views)

NNM Node Status Codes

I am playing around with the postgres database querying using pgadmin.  One thing I am trying to do is pull the list of node devices and their current status.  One thing I found was nms_node_stat which has the column prev_stat_integer and cur_stat_integer - does anyone know where I might find the definition of those values?  Meaning what does a status of 5 mean?  Or 7, etc.

 

Also, what I really want it not just the status but the description of the error.  When I go into NNMi it shows me "minor due to some error at some time".  I am trying to pull this out so that I may build a report to be sent to the owner of the devices letting them know they have outstanding problems that need to be resolved.

 

Would anyone know the table(s) that would give me that kind of information.  The standard extract only tells me whether it is minor, major, normal, etc. status but doesn't give me the error message(s) associated with the node.

HP Expert
Dave Young
Posts: 565
Registered: ‎09-27-2000
Message 2 of 2 (191 Views)

Re: NNM Node Status Codes

Edward,

 

 The values are

 

  0 : No Status

  1 : Normal

  2 : Disabled

  3 : Unknown

  4 : Warning

  5 : Minor

  6 : Major

  7 : Critical

 

 Unfortunately the schema is not documented so you need to hunt around.  I wrote a script using \dt  to get a list of all the tables and then \d <table>  to get the column and dependency information.   This can then help you dig around to get the information you want to use.    You might want to start with the nms_node_concl table which looks promising.

 

  However please be aware of the KCS document KM00591311.   This is stating the limitations of DB access and the care you need to take.

 

  All the best

 

Dave Y

HP Support

The views expressed in my contributions are my own and do not necessarily reflect the views and strategy of HP

If you find this or any post resolves your issue, please be sure to mark it as an accepted solution.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.