SIM Database

[Bill Watt]

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.

[David Claypool]

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]

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