HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
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
NVARCHAR(64)contactEmail
NVARCHAR(255)contactOther
NVARCHAR(24)contactTimeZone
NVARCHAR(32)contactLanguage
NVARCHAR(32)contactRole
NVARCHAR(32)contactPriority
NVARCHAR(64)contactHours
Database tables 117