SQL query lookup table for HP SIM DeviceStatus number

[Jim M Fox]

I am trying to decode the value for R_Inventory.DeviceStatus results. Currently the results is a number. Does anyone know where the lookup table is located in the DB for the numbers? I determined the following, but want to know where the actual descriptions are stored. Thanks ahead of time!

1 = Normal
3 = Minor
4 = Major
5 = Critical

[David Claypool]

What are you trying to do? There may be a better way to accomplish it.

[Jim M Fox]

I am pulling the data into a web based CDBM. I want to show status information for HP SIM and automate by directly reading the SQL data.

[David Claypool]

Do you mean CMDB, a Configuration Management Database? For CMDB purposes, the status may not be your best source, since it can change with every status poll (5 minute default interval) and asynchronously with events received. For a CMDB, I'd use the Events themselves to drive this.

[Jim M Fox]

For the most part, I am looking for those listed as critical, meaning the server is not online, and the data may not be vaild as far as model and SN. In many cases the server has been removed or replaced with new IP and will eventually get cleaned up in the CMDB. We are not using the information for notification of health, more just a snap shot in time. If you know where the table is located, great otherwise, we will be creating our own lookup for the status information.