Instruction Manual

Related procedures
• System reporting
• Editing a report
• Copying a report
Related topic
▲ Reporting
Showing SQL
You can view the SQL details behind a report. The SQL Queries page details all SQL queries that are used
to generate the report.
To show the SQL queries:
1. Select Reports→Manage Reports. The Manage Reports page appears.
2. Select the report for which you want to see the SQL details.
3. Click Run Report. The report appears.
4. Click the Show SQL queries link.
The SQL Queries page appears.
Related procedure
▲ System reporting
Related topic
▲ Reporting
Reporting views
Reporting uses the following database views to generate reports.
Database views
Several database views are included with HP Systems Insight Manager (HP SIM). These views can be used
to generate reports in HP SIM. The following views are available:
R_CellularSysCellR_BatteriesR_ArrayControllers
R_CellularSysParIOChassisR_CellularSysPartitionR_CellularSysParComplex
R_DIMMSlotsR_CPUR_ChangerDevices
R_HPVMGuestsR_FansR_EventSummary
R_lockdownStatusR_InventoryR_InstalledBoards
R_NetworkInterfaceR_MediaAccessDevicesR_LogicalDisks
R_PowerSupplyR_PhysicalDisksR_OperatingSystem
R_SoftwareR_RacksR_Process
R_StorageDeviceControllersR_StorageDeviceInventoryR_deviceLicenseInfo
R_StorageLogicalUnitsR_StoragePortsR_StorageHostBusAdapters
R_UnixLogicalMemoryR_UnixOSDetailsR_StorageDeviceCapacity
R_UnixIPRouteR_WarrantyContractR_UnixIODevices
R_HPUXLogicalVolumeR_HPUXVolumeGroupR_HPUXFileSystem
R_HPUXKernelParamR_HPUXNetworkDetailsR_HPUXLogicalVolume
R_HPUXSoftwareProductR_HPUXSoftwareBundle
R_ArrayControllers
DescriptionColumn name
System keyDeviceKey
440 Reporting