HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
NVARCHAR(64)contactEmail
NVARCHAR(255)contactOther
NVARCHAR(24)contactTimeZone
NVARCHAR(32)contactLanguage
NVARCHAR(32)contactRole
NVARCHAR(32)contactPriority
NVARCHAR(64)contactHours
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
118 HP SIM database tables