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

Appendix B

SIM_MANAGER.DB_DEVICEINFO.DEVICEKEY = SIM_MANAGER.DB_DEVICEINFOEX.DEVICEKEY

AND \

SIM_MANAGER.DEVICEPROTOCOLINFO.DEVICEKEY = SIM_MANAGER.DEVICES.DEVICEKEY AND

SIM_MANAGER.DEVICEPROTOCOLINFO.DEVICEKEY =

SIM_MANAGER.DB_DEVICEINFO.DEVICEKEY AND \

SIM_MANAGER.DEVICEPROTOCOLINFO.DEVICEKEY =

SIM_MANAGER.DB_DEVICEINFOEX.DEVICEKEY AND \

SIM_MANAGER.DEVICES.PRODUCTTYPESTR='Rack'

[IM_ENCLOSURE]

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