Tuesday 5 July 2011

SCCM SQL Query to list all the systems with their BIOS details

SELECT sys.Name0, BIOS.SMBIOSBIOSVersion0,BIOS.ReleaseDate0, BIOS.Manufacturer0
FROM v_r_system sys, v_GS_PC_BIOS BIOS
WHERE sys.ResourceID = BIOS.ResourceID
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)