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

Appendix B

SIM_MANAGER.DEVICES.SUBTYPE2 AS [devices_SubType2], \

SIM_MANAGER.DEVICES.PRODUCTNAME AS [IM_NAME1], \

SIM_MANAGER.DEVICES.FULLDNSNAME AS [devices_fullDNSName], \

SIM_MANAGER.DEVICES.OVERALLSTATUS AS [devices_OverallStatus], \

SIM_MANAGER.DEVICES.MXGUID AS [devices_MxGUID], \

SIM_MANAGER.DB_DEVICEINFO.LOCATION AS [DB_DeviceInfo_Location], \

SIM_MANAGER.DB_DEVICEINFO.DESCRIPTION AS [DB_DeviceInfo_Description], \

SIM_MANAGER.DB_DEVICEINFO.CONTACT AS [DB_DeviceInfo_Contact], \

SIM_MANAGER.DB_DEVICEINFOEX.SERIALNUMBER AS [DB_DeviceInfoEx_SerialNumber],

SIM_MANAGER.DB_DEVICEINFOEX.ASSETTAG AS [DB_DeviceInfoEx_AssetTag], \

SIM_MANAGER.DB_DEVICEINFOEX.TOTALMEMORY AS [DB_DeviceInfoEx_TotalMemory], \

SIM_MANAGER.DB_DEVICEINFOEX.ROMVERSION AS [DB_DeviceInfoEx_ROMVersion], \

SIM_MANAGER.DB_DEVICEINFOEX.OSNAME AS [DB_DeviceInfoEx_OSName], \

SIM_MANAGER.DB_DEVICEINFOEX.OSTYPE AS [DB_DeviceInfoEx_OSType], \

SIM_MANAGER.DB_DEVICEINFOEX.OSVERSION AS [DB_DeviceInfoEx_OSVersion], \

SIM_MANAGER.DB_DEVICEINFOEX.OSVENDOR AS [DB_DeviceInfoEx_OSVendor], \

SIM_MANAGER.DB_DEVICEINFOEX.OSDESCRIPTION AS

[DB_DeviceInfoEx_OSDescription], \

SIM_MANAGER.DB_DEVICEINFO.DESCRIPTION AS [IM_NAME2], \

'Storage' AS [IM_CATEGORY]

LOADTABLE=FALSE

CONDITION=SIM_MANAGER.DEVICES.DEVICEKEY =

SIM_MANAGER.DB_DEVICEINFO.DEVICEKEY AND \

SIM_MANAGER.DEVICES.DEVICEKEY = SIM_MANAGER.DB_DEVICEINFOEX.DEVICEKEY AND \

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

[IM_SWITCH]

SOURCE=SIM_MANAGER.DEVICES, SIM_MANAGER.DB_DEVICEINFOEX,

SIM_MANAGER.DB_DEVICEINFO, SIM_MANAGER.DEVICEPROTOCOLINFO

ATT=[devices_Name], \

[devices_ProductTypeStr], \

[devices_ProductSubType], \