HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
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
VARCHAR(255)productVer
VARCHAR(80)licType
VARCHAR(80)licDate
VARCHAR(80)expirationDate
DATETIMEcollectDate
VARCHAR(255)licStatus
VARCHAR(10)licSRC
deviceMxObjValues table
Abstract
DescriptionData TypeColumn Name
INTdeviceKey
CHAR(128)createdBy
BIGINTcreatedTime
60 HP SIM database tables