To update an old post, here’s some SQL for listing out BIOS versions per model from WSUS 3:
SELECT COUNT([tbComputerTarget].[IPAddress]) as Count,
[tbComputerTargetDetail].[ComputerModel],
[tbComputerTargetDetail].[BiosVersion]
FROM [SUSDB].[dbo].[tbComputerTarget]
JOIN [SUSDB].[dbo].[tbComputerTargetDetail] on [tbComputerTarget].[TargetID] = [tbComputerTargetDetail].[TargetID]
group by [tbComputerTargetDetail].[ComputerModel], [tbComputerTargetDetail].[BiosVersion] order by [tbComputerTargetDetail].[ComputerModel]
Land of the Lemmings v2
common sense and reasoning will not be tolerated
