Weekly Tip 29

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

Share:

Facebook
Twitter
LinkedIn

Contact Us

=
On Key

More Posts

WME Security Briefing 27 May 2024

Kinsing Hacker Group Exploits Docker Vulnerabilities Overview Recent investigations have shown that the hacker group Kinsing is actively exploiting Docker vulnerabilities to gain unauthorized access to systems. The modified hacker group targets misconfigured Docker API ports deployed with cryptocurrency mining malware.

Read More »
WME Cybersecurity Briefings No. 010
Cyber Security

WME Security Briefing 20 May 2024

Advanced Persistent Threats: North Korean Hackers Launch Golang Malware Overview A new malware strain, called Titan Stealer, is currently actively circulating in the threat landscape, targeting a variety of personal data and linked to North Korean state-sponsored cyber espionage

Read More »
WME Cybersecurity Briefings No. 009
Cyber Security

WME Security Briefing 08 May 2024

Exploitable vulnerability in Microsoft Internet Explorer, used to deploy VBA Malware Overview Cybersecurity researchers discovered a severe exploitation targeting a bug that had already been patched in the Microsoft Internet Explorer browser. Their report added that

Read More »
Be assured of everything

Get WME Services

Stay ahead of the competition with our Professional IT offerings.

=