was successfully added to your cart.

Weekly Tip

By December 1, 2015Uncategorized

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