Hp Systems Insight Manager Bedienungsanleitung PDF herunterladen (Seite 57)

Appendix A

CAST ([DB_DeviceInfoEx].[OSVendor] AS VARCHAR) AS

[DB_DeviceInfoEx_OSVendor], \

CAST ([DB_DeviceInfoEx].[OSDescription] AS VARCHAR) AS

[DB_DeviceInfoEx_OSDescription], \

CAST ([DB_DeviceInfoEx].[OSName] AS VARCHAR) + ' - ' + \

CAST ([DB_DeviceInfoEx].[OSDescription] AS VARCHAR) + ' - ' + \

CAST ([DB_DeviceInfo].[Description] AS VARCHAR) + ' - ' + \

CAST ([DB_DeviceInfo].[Location] AS VARCHAR) + ' - ' + \

CAST ([DB_DeviceInfo].[Contact] AS VARCHAR) AS [IM_NAME2], \

'Printer' AS [IM_CATEGORY]

CONDITION=[devices].[DeviceKey] = [DB_DeviceInfo].[DeviceKey] AND \

[devices].[DeviceKey] = [DB_DeviceInfoEx].[DeviceKey] AND \

[DB_DeviceInfo].[DeviceKey] = [DB_DeviceInfoEx].[DeviceKey] AND \

[deviceProtocolInfo].[DeviceKey] = [devices].[DeviceKey] AND \

[deviceProtocolInfo].[DeviceKey] = [DB_DeviceInfo].[DeviceKey] AND \

[deviceProtocolInfo].[DeviceKey] = [DB_DeviceInfoEx].[DeviceKey] AND \

[devices].[ProductTypeStr]='Printer'

LOADTABLE=FALSE

ORDERBY=[devices].[Name] ASC

[IM_MGMTPROC]

SOURCE=[DB_DeviceInfo], [DB_DeviceInfoEx], [devices], [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], \

1 2 ... 52 53 54 55 56 57 58 59 60 61 62 ... 110 111

Keine Kommentare

Hp Systems Insight Manager Bedienungsanleitung Seite 57