topic Re: SIM Database in Server Management - Systems Insight Manager

SIM Database

Bill Watt — Thu, 28 Jun 2007 09:37:19 GMT

I am trying to create a report in SIM and I want the CPU information. When I run the report in comes up with the error: CPU: Invalid object name 'R_CPU'.
I have looked at the SQL database and the is not any table or view with that name. How can I get this created. I know how to create views but do not know what tables or fields to use.

Re: SIM Database

David Claypool — Thu, 28 Jun 2007 10:46:14 GMT

The tables that begin with "R_..." are shadow tables for reporting...in other words, they hold copies of the data in the regular tables. These R_ tables are formatted for easier human access whereas the other tables are formatted for efficient machine operation.

Just to make sure, can you run the provided report called 'CPU - Servers' ?

You might try to force the R_ tables to build by restarting the HP SIM service or rebooting the box.

Re: SIM Database

Bill Watt — Thu, 28 Jun 2007 11:31:08 GMT

I have restarted the service and rebooted the box and still no R_CPU view.