HP Systems Insight Manager 5.3 Technical Reference Guide

DescriptionData TypeColumn Name
Installation date of this element in CIM date-time formatNVARCHAR(256)InstallDate
swd_VersionWeight is of CIM_SoftwareElement; a field
used by Software Status Polling
INTswd_VersionWeight
Not standard; a string that specifies the version of this itemNVARCHAR(64)dc_OtherVersionInfo
Used for reporting purposesSMALLINTOperationalStatus
A free-form string to provide more information for the
DeviceSW_Purpose property
NVARCHAR(512)ClassificationDescription
The HP Smart Array SAS/SATA Event Notification Service
provides event notification to the Windows 2000/Windows
Server 2003 system event log and the HP ProLiant
Integrated Management Log for systems using the HP Smart
Array SAS/SATA controller driver.
NVARCHAR(256)Description
[C:\Program Files\hp\cissesrv, HPQ:cissesrv.exe]
Software/firmware Key file name
NVARCHAR(256)IdentityInfoValue
[HPQ: SoftwarePath, CIM:SoftwareFamily Software Family
Path
NVARCHAR(256)IdentityInfoType
Firmware CategoryNVARCHAR(256)FirmwareCategory
A field used by reportingNVARCHAR(64)R_Type
A field used by reportingNVARCHAR(256)R_Date
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_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
Database tables 691