HP Systems Insight Manager - Manual (Page 93)

Appendix C
93
public.DEVICES.PRODUCTTYPESTR AS [devices_ProductTypeStr], \
public.DEVICES.PRODUCTSUBTYPE AS [devices_ProductSubType], \
public.DEVICES.SUBTYPE2 AS [devices_SubType2], \
public.devices.productname AS [IM_NAME1], \
public.DEVICES.FULLDNSNAME AS [devices_fullDNSName], \
public.DEVICES.OVERALLSTATUS AS [devices_OverallStatus], \
public.DEVICES.MXGUID AS [devices_MxGUID], \
public.DB_DEVICEINFO.LOCATION AS [DB_DeviceInfo_Location], \
public.DB_DEVICEINFO.DESCRIPTION AS [DB_DeviceInfo_Description], \
public.DB_DEVICEINFO.CONTACT AS [DB_DeviceInfo_Contact], \
public.DB_DEVICEINFOEX.SERIALNUMBER AS [DB_DeviceInfoEx_SerialNumber], \
public.DB_DEVICEINFOEX.ASSETTAG AS [DB_DeviceInfoEx_AssetTag], \
public.DB_DEVICEINFOEX.TOTALMEMORY AS [DB_DeviceInfoEx_TotalMemory], \
public.DB_DEVICEINFOEX.ROMVERSION AS [DB_DeviceInfoEx_ROMVersion], \
public.DB_DEVICEINFOEX.OSNAME AS [DB_DeviceInfoEx_OSName], \
public.DB_DEVICEINFOEX.OSTYPE AS [DB_DeviceInfoEx_OSType], \
public.DB_DEVICEINFOEX.OSVERSION AS [DB_DeviceInfoEx_OSVersion], \
public.DB_DEVICEINFOEX.OSVENDOR AS [DB_DeviceInfoEx_OSVendor], \
public.DB_DEVICEINFOEX.OSDESCRIPTION AS [DB_DeviceInfoEx_OSDescription], \
public.DB_DEVICEINFO.DESCRIPTION AS [IM_NAME2], \
'Business PC' AS [IM_CATEGORY]
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='Desktop'
ORDERBY=public.devices.Name ASC
[IM_WORKSTATION]
SOURCE=public.db_deviceinfo, public.db_deviceinfoex, public.devices,
public.deviceprotocolinfo
ATT=[devices_Name], \
[devices_ProductTypeStr], \
[devices_fullDNSName], \