Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

SIM Database

 
Bill Watt
Occasional Contributor

SIM Database

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.
2 REPLIES
David Claypool
Honored Contributor

Re: SIM Database

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.
Bill Watt
Occasional Contributor

Re: SIM Database

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