HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
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
VARCHAR(32)entitlementID
VARCHAR(32)obligationId
NVARCHAR(48)custProdId
VARCHAR(64)custDeliverId
deviceAttributes table
The Device Extended Attributes fields are defined in the following table.
DescriptionData TypeColumn Name
The value in minutes a system will be disabled
starting with the time marked by snoozeStartTime
INTsnoozeTimeMin
The initial timestamp from when a system was placed
in a disabled state
LongsnoozeStartTimeMs
deviceLicenseInfo table
Abstract
DescriptionData TypeColumn Name
INTdeviceKey
VARCHAR(255)licKey
VARCHAR(32)numberLicPurchased
VARCHAR(32)numberLicUsed
VARCHAR(80)keyVer
VARCHAR(255)productName
60 HP SIM database tables