Today i had a customer come to me and ask if i could easily gather and provide any data on the versions of BIOS firmware running around their network. After looking in to the best way to achieve this i found that WSUS automatically gathers this information when any client machines check in, however there is no export function within the WSUS console to gather this data into a usable format.
As the data is there we can get to it directly using SQL Management Studio or SQLCMD (https://www.microsoft.com/en-us/download/details.aspx?id=53591)
Simply install either of the above tools and connect to the SQL Database hosting WSUS this will either be on a SQL server or hosted locally on WID and run the following script
use SUSDB
select distinct ComputerModel,BiosVersion,FullDomainName
from tbComputerTargetDetail td, tbComputerTarget t
where t.target_id = td.target_id
