HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
A field used by reportingNVARCHAR(256)R_Status
Stores the latest version of each software with a
matching component in the repository
NVARCHAR(100)LatestVersion
Stores the version of software available in the
VCRM’s sw fw baseline
NVARCHAR(100)SWFWBaselineVersion
CIM_StoragePool table
DescriptionData TypeColumn Name
Used to uniquely identify CIM_StorageVolumeBIGINTStoragePool_LUID
Used to partially identify CIM_StorageVolumeBIGINTNodeID
Used to partially identify CIM_StorageVolumeBIGINTSnapShotID
Used for reporting purposesNVARCHAR(255)ElementName
Used for reporting purposesNVARCHAR(255)InstanceID
Used for reporting purposesNVARCHAR(255)PoolID
Used for reporting purposesBITPrimordial
Used for reporting purposesBIGINTTotalManagedSpace
Used for reporting purposesBIGINTRemainingManagedSpace
CIM_StorageSetting table
DescriptionData TypeColumn Name
Used to uniquely identify
CIM_StorageVolume
BIGINTstorageSetting_LUID
Used to partially identify
CIM_StorageVolume
BIGINTNodeID
Used to partially identify
CIM_StorageVolume
BIGINTSnapshotID
Used for reporting purposesNVARCHAR(255)ElementName
Used for reporting purposesNVARCHAR(255)InstanceID
CIM_StorageVolume table
DescriptionData TypeColumn Name
Used to uniquely identify CIM_StorageVolumeBIGINTStorageVolume_LUID
Used to partially identify CIM_StorageVolumeBIGINTNodeID
Used to partially identify CIM_StorageVolumeBIGINTSnapShotID
Used for reporting purposesSMALLINTDataRedundancy
Used for reporting purposesNVARCHAR(255)ElementName
Used for reporting purposesSMALLINTNameFormat
Used for reporting purposesBITNoSinglePointOfFailure
46 HP SIM database tables