HP Systems Insight Manager 7.2 Database Tables

Contents
About this document......................................................................................9
Publishing History.....................................................................................................................9
1 HP SIM database tables............................................................................10
Predefined views....................................................................................................................10
Database tables.....................................................................................................................10
associated_device_data table..............................................................................................11
AuthenticationMethods_values table.....................................................................................11
CategoryGroup table ........................................................................................................11
ChangerDev_SoftwareIdent table.........................................................................................11
CIM_ActiveConnection table...............................................................................................12
CIM_Changer_Device table................................................................................................12
CIM_Chassis table.............................................................................................................12
CIM_ComponentCS table...................................................................................................13
CIM_ComputerSystem table.................................................................................................14
CIM_ComputerSystemPackage table.....................................................................................14
CIM_ControlledBy table......................................................................................................15
CIM_DeviceSAPImplementation table....................................................................................15
CIM_DeviceSoftwareIdentity table........................................................................................15
CIM_ElementCapabilities table............................................................................................15
CIM_ElementSettingData table.............................................................................................15
CIM_Fan table..................................................................................................................15
CIM_FileSystem table.........................................................................................................16
CIM_HostedStoragePool table.............................................................................................17
CIM_IPProtocolEndpoint table..............................................................................................17
CIM_IPRoute table..............................................................................................................17
CIM_iSCSICapabilities table...............................................................................................18
CIM_iSCSIConn_TCPProtoEnd table.....................................................................................18
CIM_iSCSIConnection table................................................................................................18
CIM_iSCSISession table......................................................................................................19
CIM_LogicalDevice table....................................................................................................19
CIM_LogicalDisk table........................................................................................................20
CIM_LogicalPortGroup table................................................................................................21
CIM_MediaAccessDevice table............................................................................................21
CIM_MemberOfCollection table..........................................................................................22
CIM_NetworkAdapter table................................................................................................22
CIM_NetworkPipeComposition table....................................................................................25
CIM_NetworkPort table......................................................................................................25
CIM_OperatingSystem table................................................................................................26
CIM_PhysicalElement table..................................................................................................27
CIM_PhysicalMedia table...................................................................................................29
CIM_PhysicalMemory table.................................................................................................30
CIM_PhysicalPackage table.................................................................................................32
CIM_PortController table.....................................................................................................32
CIM_PowerSupply table......................................................................................................33
CIM_Process table.............................................................................................................35
CIM_Processor table..........................................................................................................37
CIM_Product table.............................................................................................................38
CIM_ProtoControlAccessesUnit table....................................................................................39
CIM_ProtocolControllerForPort table.....................................................................................39
CIM_ProtocolControllerForUnit table.....................................................................................39
CIM_ProtocolEndpoint table................................................................................................39
Contents 3