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]