HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
CHAR(128)AggregationURL
CHAR(128)DeviceSupportClass
INTHasGlobalProperties
INTHasNodalProperties
collectionMembers table
DescriptionData TypeColumn Name
BIGINTCollectionLUID
VARCHAR(32)MemberObjectID
VARCHAR(32)ObjectType
INTPosition
SMALLINTIsHidden
SMALLINTDisplayStatusFlag
INTEditFlags
VARCHAR(64)DefaultView
collections table
DescriptionData TypeColumn Name
LUID
NVARCHAR(80)Name
VARCHAR(256)DefaultView
SMALLINTIsHidden
INTEditFlags
INTType
BIGINTSystemCollLuid
BIGINTEventCollLuid
ComputerSys_ChangerDevice table
DescriptionData TypeColumn Name
BIGINTGroupComponent
BIGINTPartComponent
ComputerSys_HAP table
DescriptionData TypeColumn Name
Used for reporting purposesBIGINTDependent
Used for reporting purposesBIGINTAntecedent
50 HP SIM database tables