HP Systems Insight Manager 7.2 Database Tables

hpmxToolBox table
DescriptionData TypeColumn Name
BIGINTLUID
NVARCHAR(16)PersistedName
NVARCHAR(255)PersistedDescription
SMALLINTIsEnabled
hpmxUser table
DescriptionData TypeColumn Name
BIGINTLUID
NVARCHAR(128PersistedName
NVARCHAR(128)FullName
VARCHAR(80)TelephoneNumber
NVARCHAR(80)EmailAddress
TEXTIPLoginInclusionRanges
TEXTIPLoginExclusionRanges
SMALLINTHidden
SMALLINTGroupBased
hpmxUserAssignedUserGroups table
DescriptionData TypeColumn Name
BIGINTUserLUID
VARCHAR(32)UserGroupID
hpmxUserGroup table
DescriptionData TypeColumn Name
BIGINTLUID
NVARCHAR(128)PersistedName
NVARCHAR(128)FullName
TEXTIPLoginInclusionRanges
TEXTIPLoginExclusionRanges
IPLoginRangesOverride helps to override the user’s
IP login range with the preferred IP login range of
the user group.
VARCHAR(1)IPLoginRangesOverride
Database tables 85