Scanning for BIOS information across the environment comes in handy when you realize you either have non stable versions or you have not updated the BIOS in a while. The following SCCM SQL query can be used to pull the data.
SELECT DISTINCT dbo.v_R_System.Name0 AS [Device Name], dbo.v_GS_COMPUTER_SYSTEM.Manufacturer0 AS Manufacturer, dbo.v_GS_COMPUTER_SYSTEM.Model0 AS Model, dbo.v_R_System.Operating_System_Name_and0 AS [Operating System], dbo.v_R_System.AD_Site_Name0 AS [AD Site], dbo.v_R_System.Full_Domain_Name0 AS Domain, dbo.v_R_System.Is_Virtual_Machine0 AS [Virtual Machine], dbo.v_R_System.Last_Logon_Timestamp0 AS [Last Logon], dbo.v_GS_PC_BIOS.Manufacturer0, dbo.v_GS_PC_BIOS.SMBIOSBIOSVersion0, dbo.v_GS_PC_BIOS.SMBIOSMajorVersion0 FROM dbo.v_GS_COMPUTER_SYSTEM RIGHT OUTER JOIN dbo.v_R_System ON dbo.v_GS_COMPUTER_SYSTEM.ResourceID = dbo.v_R_System.ResourceID LEFT OUTER JOIN dbo.v_GS_PC_BIOS ON dbo.v_R_System.ResourceID = dbo.v_GS_PC_BIOS.ResourceID
