HP Systems Insight Manager - Manual (Page 67)

Appendix A
67
[devices].[MxGUID] AS [devices_MxGUID], \
CAST ([DB_DeviceInfo].[Location] AS VARCHAR) AS [DB_DeviceInfo_Location], \
CAST ([DB_DeviceInfo].[Description] AS VARCHAR) AS
[DB_DeviceInfo_Description], \
CAST ([DB_DeviceInfo].[Contact] AS VARCHAR) AS [DB_DeviceInfo_Contact], \
CAST ([DB_DeviceInfoEx].[SerialNumber] AS VARCHAR) AS
[DB_DeviceInfoEx_SerialNumber], \
CAST ([DB_DeviceInfoEx].[AssetTag] AS VARCHAR) AS
[DB_DeviceInfoEx_AssetTag], \
[DB_DeviceInfoEx].[TotalMemory] AS [DB_DeviceInfoEx_TotalMemory], \
CAST ([DB_DeviceInfoEx].[ROMVersion] AS VARCHAR) AS
[DB_DeviceInfoEx_ROMVersion], \
CAST ([DB_DeviceInfoEx].[OSName] AS VARCHAR) AS [DB_DeviceInfoEx_OSName], \
CAST ([DB_DeviceInfoEx].[OSType] AS VARCHAR) AS [DB_DeviceInfoEx_OSType], \
CAST ([DB_DeviceInfoEx].[OSVersion] AS VARCHAR) AS
[DB_DeviceInfoEx_OSVersion], \
CAST ([DB_DeviceInfoEx].[OSVendor] AS VARCHAR) AS
[DB_DeviceInfoEx_OSVendor], \
CAST ([DB_DeviceInfoEx].[OSDescription] AS VARCHAR) AS
[DB_DeviceInfoEx_OSDescription], \
CAST ([DB_DeviceInfoEx].[OSName] AS VARCHAR) + ' - ' + \
CAST ([DB_DeviceInfoEx].[OSDescription] AS VARCHAR) + ' - ' + \
CAST ([DB_DeviceInfo].[Description] AS VARCHAR) + ' - ' + \
CAST ([DB_DeviceInfo].[Location] AS VARCHAR) + ' - ' + \
CAST ([DB_DeviceInfo].[Contact] AS VARCHAR) AS [IM_NAME2], \
'KVM' AS [IM_CATEGORY]
CONDITION=[devices].[DeviceKey] = [DB_DeviceInfo].[DeviceKey] AND \
[devices].[DeviceKey] = [DB_DeviceInfoEx].[DeviceKey] AND \
[DB_DeviceInfo].[DeviceKey] = [DB_DeviceInfoEx].[DeviceKey] AND \
[deviceProtocolInfo].[DeviceKey] = [devices].[DeviceKey] AND \
[deviceProtocolInfo].[DeviceKey] = [DB_DeviceInfo].[DeviceKey] AND \
[deviceProtocolInfo].[DeviceKey] = [DB_DeviceInfoEx].[DeviceKey] AND \
[devices].[ProductTypeStr]='KVM'
LOADTABLE=FALSE
ORDERBY=[devices].[Name] ASC
[IM_UPS]
SOURCE=[DB_DeviceInfo], [DB_DeviceInfoEx], [devices], [deviceProtocolInfo]