Get BIOS information for machines in SCCM
This requires a limited knowledge of SQL Management Studio. This query, when executed against the SCCM database, will bring back BIOS information containing the computer name, BIOS version, BIOS release date, machine manufacturer, machine model, and BIOS description. Be sure to change <collectionID> to the collection ID where you want to search (make sure to leave the single quotes). I choose to sort the list by the computer model, but you change the ORDER BY line to sort by any column.
SELECT COLL.Name, BIOS.SMBIOSBIOSVersion0, BIOS.Manufacturer0, PRO.Version0, BIOS.ReleaseDate0, BIOS.Description0
FROM v_FullCollectionMembership COLL, v_GS_PC_BIOS BIOS, v_GS_COMPUTER_SYSTEM_PRODUCT PRO
WHERE COLL.ResourceID = BIOS.ResourceID AND COLL.ResourceID = PRO.ResourceID AND COLL.CollectionID = ‘<collectionID>’
ORDER BY PRO.Version0
