HP Systems Insight Manager 7.1 Database Tables

SIM_SysCustomer table
DescriptionData TypeColumn Name
BIGINTcustomerLuid
NVARCHAR(120)companyName
NVARCHAR(120)address1
NVARCHAR(120)address2
NVARCHAR(64)city
VARCHAR(50)state
NVARCHAR(12)postalCode
NVARCHAR(32)country
NVARCHAR(24)custTimeZone
Snapshot table
DescriptionData TypeColumn Name
LUID uniquely defining the snapshotBIGINTSnapshotID
OverallStatus of the Snapshot: Code indicating if the
snapshot was successful
NVARCHAR(64)OverallStatus
Contains the user-defined tagNVARCHAR(256)SnapshotTag
Stored as MS since the EpochBIGINTCollectionDateTime
SPAllocatedFromStoragePool table
DescriptionData TypeColumn Name
LUID uniquely defining the SPAllocFromStoragePoolBIGINTSPAllocFromStoragePool_LUID
Used for reporting purposesBIGINTNodeID
Used for reporting purposesBIGINTSnapshotID
Used for reporting purposesBIGINTAntecedent
Used for reporting purposesBIGINTDependent
Used for reporting purposesBIGINTSpaceConsumed
stm_rules_dmi table
DescriptionData TypeColumn Name
INTpriority
CHAR(1)override_flag
CHAR(1)modified_by_user_flag
NVARCHAR(128)productModel
INTproductType
INTproductSubType
118 HP SIM database tables