Querying Hardware Serial Numbers and Memory Module Information

Did you know you could retrieve hardware serial numbers and memory module information from your Inventory Solution data? It's possible by joining [Inv_AeX_HW_Serial_Number] and [Inv_AeX_HW_Memory_Modules] tables with [Inv_AeX_AC_Identification].

Here's the syntax:

QUERY:

SELECT DISTINCT(ACI.[Name]) AS 'Machine Name', AHS.[Serial Number] AS 'Serial Number', MM.[Size], MM.[Type]
FROM [Inv_AeX_AC_Identification] ACI
INNER JOIN [Inv_AeX_HW_Serial_Number] AHS ON ACI.[_ResourceGuid] = AHS.[_ResourceGuid]
JOIN [Inv_AeX_HW_Memory_Modules] MM ON MM.[_ResourceGuid] = ACI.[_ResourceGuid]  
ORDER BY ACI.[Name]