HP OpenView Service Desk and HP Systems Insight Manager Integration User Guide

Appendix C

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='Server'

ORDERBY=public.devices.Name ASC

[IM_DESKTOP]

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], \