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]
Nice query Eshwar, Wouldn't
Nice query Eshwar,
You may be a little better off with a set left joins there. This would ensure you show computers that have Serial Number or Memory Module information missing.
Now I am wondering if this would be a low or very low percentage of your standard result set?
In all cases, SQL rules :D
Ludovic FERRE
Princ. Remote Product Specialist
Symantec
Would you like to reply?
Login or Register to post your comment.