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

Error message

Warning: Cannot modify header information - headers already sent by (output started at /mnt/home/visuafus/public_html/bahusa.net/includes/common.inc:2861) in drupal_send_headers() (line 1551 of /mnt/home/visuafus/public_html/bahusa.net/includes/bootstrap.inc).

Error: Call to undefined function mail() in DefaultMailSystem->mail() (line 79 of /mnt/home/visuafus/public_html/bahusa.net/modules/system/system.mail.inc).

You are here

ConfigMgr DB - Lenovo BIOS Versions (SQL)

Error message

Error