HP Systems Insight Manager 5.2 Update 2 Technical Reference Guide

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_deviceLicenseInfoR_CPUR_ChangerDevices
R_FansR_EventSummaryR_DIMMSlots
R_InventoryR_InstalledBoardsR_HPVMGuests
R_MediaAccessDevicesR_LogicalDisksR_lockdownStatus
R_PhysicalDisksR_OperatingSystemR_NetworkInterface
R_RacksR_ProcessR_PowerSupply
R_StorageDeviceInventoryR_SWFWBaselineInformationR_Software
R_StoragePortsR_StorageHostBusAdaptersR_StorageDeviceControllers
R_UnixOSDetailsR_StorageDeviceCapacityR_StorageLogicalUnits
R_WarrantyContractR_UnixIODevicesR_UnixLogicalMemory
R_HPUXVolumeGroupR_HPUXFileSystemR_UnixIPRoute
R_HPUXNetworkDetailsR_HPUXLogicalVolumeR_HPUXLogicalVolume
R_HPUXSoftwareProductR_HPUXSoftwareBundleR_HPUXKernelParam
R_ArrayControllers
DescriptionColumn name
System keyDeviceKey
Name of the systemDeviceName
Board nameBoardName
Controller modelModel
Controller Product Revision numberVersion
Board firmware revisionFirmwareRev
Controller Serial numberSerialNumber
Slot number in the systemSlotNumber
Snapshot IDSnapshotID
TagTag
System reporting 513