HP Systems Insight Manager 7.1 Database Tables

DeviceUrls table
DescriptionData TypeColumn Name
INTDeviceKey
CHAR(128)UrlName
CHAR(255)Url
VARCHAR(255)UrlDescription
DeviceUrlStrings table
DescriptionData TypeColumn Name
CHAR(60)UrlName
CHAR(70)UrlStringType
CHAR(255)UrlStringKey
DeviceUrlTypes table
DescriptionData TypeColumn Name
CHAR(128)UrlName
INTUrlType
INTUserClass
CHAR(200)UrlInfo
CHAR(100)UrlBuilder
CHAR(100)UrlStatusSource
Devices table
The Devices table contains discovered system information. This is the primary table used to define
system related data. The Devices fields are defined in the following table.
DescriptionData TypeColumn Name
The DeviceKey associates a system with its collected
set of data (System information is linked to the device
table using the DeviceKey)
INTDeviceKey
The name of the systemCHAR (256)Name
Globally Unique Identifier, a unique key used to
identify this system on the network in the event that
VARCHAR (128)GUID
it changes its network address (This requires that a
system support retrieval of this value in order for it
to be stored here.)
64 HP SIM database tables