HP Systems Insight Manager - Manual (Page 440)

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_CellularSysCell R_Batteries R_ArrayControllers
R_CellularSysParIOChassis R_CellularSysPartition R_CellularSysParComplex
R_DIMMSlots R_CPU R_ChangerDevices
R_HPVMGuests R_Fans R_EventSummary
R_lockdownStatus R_Inventory R_InstalledBoards
R_NetworkInterface R_MediaAccessDevices R_LogicalDisks
R_PowerSupply R_PhysicalDisks R_OperatingSystem
R_Software R_Racks R_Process
R_StorageDeviceControllers R_StorageDeviceInventory R_deviceLicenseInfo
R_StorageLogicalUnits R_StoragePorts R_StorageHostBusAdapters
R_UnixLogicalMemory R_UnixOSDetails R_StorageDeviceCapacity
R_UnixIPRoute R_WarrantyContract R_UnixIODevices
R_HPUXLogicalVolume R_HPUXVolumeGroup R_HPUXFileSystem
R_HPUXKernelParam R_HPUXNetworkDetails R_HPUXLogicalVolume
R_HPUXSoftwareProduct R_HPUXSoftwareBundle
R_ArrayControllers
Description Column name
System key DeviceKey
440 Reporting