Forum Discussion
How to capture BIOS Version through MECM/Intune
You can look at Intune Portal, pick a device and then drill down into the Hardware option under monitor. You can probably use graph to gather it from all of your devices and build a report.
or
ConfigMgr collects this data, you can retrieve it via SQL query
select the data from: view: v_GS_PC_BIOS
for a bit nicer query:
SELECT DISTINCT SYS.Netbios_Name0 as 'Computer Name'
,WS.LastHWScan
,DATEDIFF(day,WS.LastHWScan,GETDATE()) as 'Days Since HWScan'
,SE.SerialNumber0 AS [Serial Number]
,bb.Product0
,cs.Model0 AS Model
,cs.Manufacturer0 AS Manufacturer
,SYS.BuildExt
,SYS.User_Name0 [Last Logon User Name]
,BIOS.SMBIOSBIOSVersion0
FROM v_GS_WORKSTATION_STATUS WS
LEFT JOIN v_R_System SYS ON WS.ResourceID = SYS.ResourceID
LEFT JOIN v_GS_PC_BIOS BIOS ON WS.ResourceID = BIOS.ResourceID
LEFT JOIN v_GS_COMPUTER_SYSTEM cs ON CS.ResourceID = SYS.ResourceID
LEFT JOIN dbo.v_GS_SYSTEM_ENCLOSURE SE ON SE.ResourceID = SYS.ResourceID
Join v_GS_BASEBOARD bb on bb.ResourceID = SYS.ResourceID
join dbo.v_FullCollectionMembership FCM on FCM.ResourceID = SYS.ResourceID
Where
FCM.CollectionId = 'MCM00035'
(Make sure you modify the Collection ID for the collection you want to limit the query to)
Just to add to Gary's comment. You should be able to use Intune Data Warehouse to report on the version too.