topic Re: SQL query lookup table for HP SIM DeviceStatus number in Server Management - Systems Insight Manager

SQL query lookup table for HP SIM DeviceStatus number

Jim M Fox — Tue, 23 Oct 2007 14:03:58 GMT

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

Re: SQL query lookup table for HP SIM DeviceStatus number

David Claypool — Tue, 23 Oct 2007 16:22:10 GMT

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

Re: SQL query lookup table for HP SIM DeviceStatus number

Jim M Fox — Tue, 23 Oct 2007 16:43:23 GMT

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.

Re: SQL query lookup table for HP SIM DeviceStatus number

David Claypool — Tue, 23 Oct 2007 16:57:17 GMT

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.

Re: SQL query lookup table for HP SIM DeviceStatus number

Jim M Fox — Tue, 23 Oct 2007 17:06:47 GMT

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.