HP Systems Insight Manager - Manual (Page 59)

Appendix A
59
[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]='MgmtProc'
LOADTABLE=FALSE
ORDERBY=[devices].[Name] ASC
[IM_STORAGE]
SOURCE=[DB_DeviceInfo], [DB_DeviceInfoEx], [devices], [deviceProtocolInfo]
ATT=[devices_Name], \
[devices_ProductTypeStr], \
[devices_FullDNSName], \
[devices_OverallStatus], \
[devices_MxGUID], \
[DB_DeviceInfo_Location], \
[DB_DeviceInfo_Description], \
[DB_DeviceInfo_Contact], \
[DB_DeviceInfoEx_SerialNumber], \
[DB_DeviceInfoEx_AssetTag], \
[DB_DeviceInfoEx_TotalMemory], \
[DB_DeviceInfoEx_ROMVersion], \
[DB_DeviceInfoEx_OSName], \
[DB_DeviceInfoEx_OSType], \
[DB_DeviceInfoEx_OSVersion], \
[DB_DeviceInfoEx_OSVendor], \
[DB_DeviceInfoEx_OSDescription], \
[deviceProtocolInfo_PrimaryAddress], \
[IM_NAME1], \
[IM_NAME2], \
[IM_CATEGORY]
COLUMNS=[devices].[Name] AS [devices_Name], \
CAST ([deviceProtocolInfo].[PrimaryAddress] AS VARCHAR) AS
[deviceProtocolInfo_PrimaryAddress], \
[devices].[ProductTypeStr] AS [devices_ProductTypeStr], \