HP Systems Insight Manager - Manual (Page 74)

Appendix B
74
SIM_MANAGER.DEVICEPROTOCOLINFO.DEVICEKEY =
SIM_MANAGER.DB_DEVICEINFO.DEVICEKEY AND \
SIM_MANAGER.DEVICEPROTOCOLINFO.DEVICEKEY =
SIM_MANAGER.DB_DEVICEINFOEX.DEVICEKEY AND \
SIM_MANAGER.DEVICES.PRODUCTTYPESTR='Desktop'
[IM_WORKSTATION]
SOURCE=SIM_MANAGER.DEVICES, SIM_MANAGER.DB_DEVICEINFOEX,
SIM_MANAGER.DB_DEVICEINFO, SIM_MANAGER.DEVICEPROTOCOLINFO
ATT=[devices_Name], \
[devices_ProductTypeStr], \
[devices_ProductSubType], \
[devices_SubType2], \
[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_ip], \
[IM_NAME1], \
[IM_NAME2], \
[IM_PARENT], \
[IM_CATEGORY]
COLUMNS=SIM_MANAGER.DEVICES.NAME AS [devices_Name], \
SIM_MANAGER.DEVICEPROTOCOLINFO.PRIMARYADDRESS AS [deviceProtocolInfo_ip] ,\
SIM_MANAGER.DEVICES.PRODUCTTYPESTR AS [devices_ProductTypeStr], \
SIM_MANAGER.DEVICES.PRODUCTSUBTYPE AS [devices_ProductSubType], \
SIM_MANAGER.DEVICES.SUBTYPE2 AS [devices_SubType2], \
SIM_MANAGER.DEVICES.PRODUCTNAME AS [IM_NAME1], \