1 2 3
| SELECT dbo_Inv_AeX_AC_Identification.[_id], dbo_Inv_AeX_AC_Identification.Name, dbo_Inv_AeX_AC_Identification.Domain, dbo_Inv_AeX_AC_Identification.[System Type], dbo_Inv_AeX_AC_Identification.[OS Name], Max(dbo_Inv_AeX_AC_Identification.[OS Revision]) AS [MaxDeOS Revision], Max(dbo_Inv_AeX_AC_Identification.[Last Logon User]) AS [MaxDeLast Logon User], Max(dbo_Inv_AeX_AC_Identification.[Last Logon Domain]) AS [MaxDeLast Logon Domain], Max(dbo_Inv_AeX_AC_Identification.[Client Date]) AS [MaxDeClient Date], dbo_Inv_AeX_AC_Identification.[BIOS Serial Number], dbo_Inv_AeX_AC_Identification.[Hardware Serial Number], dbo_Inv_AeX_AC_TCPIP.[MAC Address], dbo_Inv_AeX_AC_TCPIP.[IP Address], Max(dbo_Inv_HW_Logical_Disk.[Size (Bytes)]) AS [MaxDeSize (Bytes)], dbo_vHWComputerSystem.Manufacturer, dbo_vHWComputerSystem.Model, dbo_vHWComputerSystem.[Total Physical Memory (Bytes)]
FROM (((dbo_Inv_AeX_AC_Identification INNER JOIN dbo_Inv_AeX_AC_TCPIP ON dbo_Inv_AeX_AC_Identification.[_ResourceGuid] = dbo_Inv_AeX_AC_TCPIP.[_ResourceGuid]) INNER JOIN dbo_Inv_HW_Logical_Disk ON dbo_Inv_AeX_AC_Identification.[_ResourceGuid] = dbo_Inv_HW_Logical_Disk.[_ResourceGuid]) INNER JOIN dbo_Inv_HW_Computer_System ON dbo_Inv_AeX_AC_Identification.[_ResourceGuid] = dbo_Inv_HW_Computer_System.[_ResourceGuid]) INNER JOIN dbo_vHWComputerSystem ON dbo_Inv_HW_Computer_System.[_ResourceGuid] = dbo_vHWComputerSystem.[_ResourceGuid]
GROUP BY dbo_Inv_AeX_AC_Identification.[_id], dbo_Inv_AeX_AC_Identification.Name, dbo_Inv_AeX_AC_Identification.Domain, dbo_Inv_AeX_AC_Identification.[System Type], dbo_Inv_AeX_AC_Identification.[OS Name], dbo_Inv_AeX_AC_Identification.[BIOS Serial Number], dbo_Inv_AeX_AC_Identification.[Hardware Serial Number], dbo_Inv_AeX_AC_TCPIP.[MAC Address], dbo_Inv_AeX_AC_TCPIP.[IP Address], dbo_vHWComputerSystem.Manufacturer, dbo_vHWComputerSystem.Model, dbo_vHWComputerSystem.[Total Physical Memory (Bytes)]; |
Partager