HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
BIGINTcollectiontime
NVARCHAR(64)entitlementStatus
NVARCHAR(48)startDate
BIGINTstartDateEpoch
NVARCHAR(48)endDate
BIGINTendDateEpoch
NVARCHAR(1024)offers
NVARCHAR(1024)responseTime
NVARCHAR(255)coverageWindow
NVARCHAR(64)warType
NVARCHAR(64)incidentStatus
NVARCHAR(1024)serviceLevel
NVARCHAR(48)obligationStartDate
NVARCHAR(48)obligationEndDate
NTEXTrawOOSXml
INTskipEntitlement
NVARCHAR(20)productID
NVARCHAR(255)prodDescription
NVARCHAR(40)serialNumber
NVARCHAR(20)obligationDetail
NVARCHAR(255)entitlementSummary
NVARCHAR(20)custContractRef
NVARCHAR(20)svcAgreementID
NVARCHAR(20)contractID
NVARCHAR(20)ampID
NVARCHAR(20)carePackID
NVARCHAR(50)sar
SIM_SysContact table
DescriptionData TypeColumn Name
bigINTcontactLuid
NVARCHAR(8)contactSalutation
NVARCHAR(120)contactFirstName
NVARCHAR(120)contactLastName
NVARCHAR(32)contactPhone
NVARCHAR(32)alternatePhone
NVARCHAR(64)contactTitle
Database tables 117