HP Systems Insight Manager 7.1 Database Tables

ServiceNotices table
DescriptionData TypeColumn Name
INTNoticeID
INTProviderID
CHAR(40)ServiceID
CHAR(20)SequenceNumber
INTEventStatus
CHAR(256)EventURL
ServiceProvider table
DescriptionData TypeColumn Name
INTProviderID
CHAR(256)ProviderName
CHAR(256)ProviderURL
CHAR(256)DefaultEventURL
SIM_NodeCertificate table
DescriptionData TypeColumn Name
BIGINTnodeCertificate_LUID
BIGINTnodeID
INTportID
NVARCHAR(64)certificateAlias
SIM_NodeEntitlement table
DescriptionData TypeColumn Name
BIGINTnodeID
BIGINTentitlementLUID
BIGINTcollectiontime
NVARCHAR(64)entitlementStatus
NVARCHAR(48)startDate
BIGINTstartDateEpoch
NVARCHAR(48)endDate
BIGINTendDateEpoch
NVARCHAR(1024)offers
NVARCHAR(1024)responseTime
NVARCHAR(255)coverageWindow
NVARCHAR(64)warType
116 HP SIM database tables