Hp Systems Insight Manager Manuel d'utilisateur télécharger pdf (Page 51)

Appendix A

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

[IM_NAME1], \

[IM_NAME2], \

[IM_CATEGORY]

COLUMNS=[devices].[Name] AS [devices_Name], \

CAST ([deviceProtocolInfo].[PrimaryAddress] AS VARCHAR) AS

[deviceProtocolInfo_PrimaryAddress], \

[devices].[ProductTypeStr] AS [devices_ProductTypeStr], \

CAST ([devices].[ProductName] AS VARCHAR) AS [IM_NAME1], \

[devices].[fullDNSName] AS [devices_fullDNSName], \

[devices].[OverallStatus] AS [devices_OverallStatus], \

[devices].[MxGUID] AS [devices_MxGUID], \

CAST ([DB_DeviceInfo].[Location] AS VARCHAR) AS [DB_DeviceInfo_Location], \

CAST ([DB_DeviceInfo].[Description] AS VARCHAR) AS

[DB_DeviceInfo_Description], \

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

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

[DB_DeviceInfoEx_SerialNumber], \

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

[DB_DeviceInfoEx_AssetTag], \

[DB_DeviceInfoEx].[TotalMemory] AS [DB_DeviceInfoEx_TotalMemory], \

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

[DB_DeviceInfoEx_ROMVersion], \

CAST ([DB_DeviceInfoEx].[OSName] AS VARCHAR) AS [DB_DeviceInfoEx_OSName], \

CAST ([DB_DeviceInfoEx].[OSType] AS VARCHAR) AS [DB_DeviceInfoEx_OSType], \

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

[DB_DeviceInfoEx_OSVersion], \

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) + ' - ' + \

1 2 ... 46 47 48 49 50 51 52 53 54 55 56 ... 110 111

Pas de commentaire

Hp Systems Insight Manager Manuel d'utilisateur Page 51