ConfigMgr DB - Lenovo BIOS Versions (SQL)

  • 14 January 2020
  • Sean Huggans

The following query will give a list of Lenovo machines with their model name (not build), and BIOS versions from the CM_ DB.

Query: 
SELECT 
s.Netbios_Name0 AS 'ComputerName',
CompInfo.Vendor0 AS 'Manufacturer',
CompInfo.Version0 AS 'Model',
BIOSInfo.BIOSVersion0 AS 'BIOSVersion'
 
FROM v_R_System AS s
INNER JOIN v_GS_PC_BIOS AS [BIOSInfo] ON BIOSInfo.ResourceID = s.ResourceID
INNER JOIN v_GS_COMPUTER_SYSTEM_PRODUCT AS [CompInfo] ON CompInfo.ResourceID = s.ResourceID WHERE CompInfo.Vendor0 = 'LENOVO' ORDER BY Model
Query Type: 
SQL Query