Find Physical Disk Serial Numbers (SQL)

29 March 2022
Sean Huggans

Returns a list of serial numbers for physical disks from the ConfigMgr database.

Query:

SELECT Sys.Name0,
PD.Model0,
PD.SerialNumber0
FROM v_GS_PHYSICAL_DISK PD
INNER JOIN v_R_System SYS
    ON PD.ResourceID = SYS.ResourceID 
	WHERE PD.SerialNumber0 IS NOT NULL -- Comment this out to include nulls (usually for VM virtual Disks)
	ORDER BY name0

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

Find Physical Disk Serial Numbers (SQL)

Error message

Error