How to pull hard drive and other serial numbers with SCCM Current Branch?

could you please describe your question a bit more to be able to help.

Hi ,

We need to collect the serial numbers of all the hard drives in our environment. We have SCCM Current branch currently running. Can you let me know how we can collect the serial number of Hard drives from our clients?

which sccm version?

SCCM 1810

if you have access to SQL you can run this query against the main SCCM database

You can add more drives to cover all disks

Use [DATABASENAME]
select * from v_GS_LOGICAL_DISK where DeviceID0 = 'C:' OR DeviceID0 = 'D:' or DeviceID0 = 'E:' or DeviceID0 = 'F:'

Select allOpen in new window

Hi Vikas,

This query gives the volume serial number , but we need the serial number of the Hard drive . The table you are using to get the data is for logical disk....but we need the serial number for the hard drive.....do you think is it same ?

What do you think about the following query ?

Select v_R_System.Netbios_Name0,v_GS_PHYSICALDISK.SerialNumber0 from v_GS_PHYSICALDISK inner join v_R_System on v_GS_PHYSICALDISK.ResourceID = v_R_System.ResourceID

You can use

select * from v_GS_DISK

Select allOpen in new window

But i think this query which i gave can only work in 1902 .. what should we do for 1810 ?

But Vikas the query you gave does not give serial number of the hard drive?

Hello Sukhdeep,

SCCM stores data for Physical disk in v_GS_DISK and memory in v_GS_PHYSICAL_MEMORY. You can see all the values it stores by running

select * from v_GS_PHYSICAL_MEMORY

select * from v_GS_DISK

Select allOpen in new window

As you see it provides you only the model number. To be able to get the serial number you can create a simple powershell or bat script and run it against list of computers

wmic diskdrive get Name, Manufacturer, Model, InterfaceType, MediaType, SerialNumber.

Select allOpen in new window

Are you talking about PCs or servers with RAID controllers? You won't get the underlying hard disk details if there is a RAID controller in the way,

Actually all are PC without raid and there are few servers also

In general for the servers you would have to use the RAID controller's CLI