HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
INTHeight
INTWidth
INTDepth
INTMaxNumItems
INTNumBladeSlotsUsed
INTSwitchesPresent
INTMaxNumItemsXDir
INTMaxNumItemsYDir
INTSlotsUsedXDir
INTSlotsUsedYDir
CHAR(80)Source
deviceExtendedAttributes table
Abstract
DescriptionData TypeColumn Name
The deviceKey associates a system with its collected
set of data (system information is linked to a system
using the DeviceKey from the devices table)
INTdeviceKey
NVARCHAR(255)assetType
NVARCHAR(255)assetClass
NVARCHAR(255)sysAdmin
NVARCHAR(255)sysDepartment
NVARCHAR(255)sysSupplier
NVARCHAR(255)warrantyText
NVARCHAR(255)serviceDate
NVARCHAR(255)serviceContract
NVARCHAR(255)serviceContact
NVARCHAR(64)purchasePrice
NVARCHAR(64)purchaseDate
NVARCHAR(512)comments
INThwPollFailCount
NVARCHAR(255)applications
INTsnoozeTimeMin
BIGINTsnoozeStartTimeMs
VARCHAR(32)custSerialNo
VARCHAR(32)sysCountryCode
VARCHAR(16)entitlementType
Database tables 59