HP Systems Insight Manager - Manual (Page 106)

Appendix C
106
LOADTABLE=FALSE
CONDITION=public.devices.DeviceKey = public.DB_DeviceInfo.DeviceKey AND \
public.devices.DeviceKey = public.DB_DeviceInfoEx.DeviceKey AND \
public.DB_DeviceInfo.DeviceKey = public.DB_DeviceInfoEx.DeviceKey AND \
public.deviceProtocolInfo.DeviceKey = public.devices.DeviceKey AND \
public.deviceProtocolInfo.DeviceKey = public.DB_DeviceInfo.DeviceKey AND \
public.deviceProtocolInfo.DeviceKey = public.DB_DeviceInfoEx.DeviceKey AND \
public.devices.ProductTypeStr='KVM'
ORDERBY=public.devices.Name ASC
[IM_UPS]
SOURCE=public.db_deviceinfo, public.db_deviceinfoex, public.devices,
public.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=public.devices.name AS [devices_Name], \
public.DEVICEPROTOCOLINFO.PRIMARYADDRESS AS
[deviceProtocolInfo_PrimaryAddress], \