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