NNM Node Status Codes (276 Views)
Super Advisor
Posts: 339
Registered: ‎03-13-2008
Message 1 of 2 (276 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
Posts: 718
Registered: ‎09-27-2000
Message 2 of 2 (232 Views)

Re: NNM Node Status Codes



 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.