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)
- Garth-MVPSep 18, 2023Iron Contributor
Just to add to Gary's comment. You should be able to use Intune Data Warehouse to report on the version too.