HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
Operating system name. Note: This is not the same
OSName from the tool definitions files; this is the
OSNameStr value from mxnode
CHAR (100)OSName
The OSType identifier that is used for tool definitions
OSName field; this is a value like WINNT, HPUX,
or LINUX
CHAR(100)OSType
Operating system versionCHAR (100)OSVersion
Vendor name of the operating systemCHAR(64)OSVendor
If present, the name of the cluster to which this system
belongs
CHAR (100)ClusterName
The description of the host operating systemCHAR(100)OSDescription
System trust state for HP web enabled agentsIntTrustStatus
NOTE: An asterisk (*) indicates that the field is part of the primary key of the table. Where
multiple fields in the same table show an asterisk, the primary key connects to each.
db_ThirdPartyLink table
DescriptionData TypeColumn Name
NCHAR(255)category
NCHAR(255)linkName
NCHAR(255)url
DC_CategoryChildren table
Abstract
DescriptionData TypeColumn Name
INTClassId
INTPollId
DC_DeviceDCState table
Abstract
DescriptionData TypeColumn Name
INTDeviceKey
DATETIMELastDCTimeStarted
DATETIMELastDCTimeCompleted
DATETIMELastHDCTimeStarted
INTDCFlags
INTcollectionState
54 HP SIM database tables