PENDING Query to find systems where OS is installed on disk 1

[Manoj Somappa]

Hi All,

We are in process of updating windows 7 to windows 10 (IPU). we have some systems where OS is installed on Disk 1. Would like to pull a report of all systems where OS is installed on disk 1.

In the past, specific models where having 2 HDD and OS was installed on disk 1. later the configurations changed for these models and came with only 1 HDD.

Can anyone help me with SQL/SCCM query.

Thanks in advance.

 

[Garth]

What do you have already for you query? What is not working with it?

 

[Manoj Somappa]

What do you have already for you query? What is not working with it?

Hi Garth,

I could not find any attribute to query for systems where OS is installed on disk 1. so i dont have any query which is either partially working or not working at all.

 

[Garth]

Have you looked the resource explorer see if there is a link between this inventory items?
- Disk drive
- Disk partitions
- Logical Disk
- OS

 

[Manoj Somappa]

yes indeed with disk drive but the report is not accurate.

 

[Garth]

what is not accurate?

 

[Manoj Somappa]

There are few systems which is included in the report even when the system has one HDD but shows as OS installed on HardDisk1
By the way i am looking here in Resource explorer.
Microsoft Windows 10 Enterprise|C:\WINDOWS|\Device\Harddisk1\Partition2 \Device\HarddiskVolume2

 

[Garth]

What report would be? You have to remember I can't see what you are seeing, you have to point me to exactly what you are looking at.

 

[Sungpill Han]

You can pull out report of OS installed volume

SELECT v_GS_COMPUTER_SYSTEM.ResourceID, v_GS_COMPUTER_SYSTEM.Name0, v_GS_OPERATING_SYSTEM.BootDevice0, v_GS_OPERATING_SYSTEM.Version0, v_GS_COMPUTER_SYSTEM.UserName0
FROM v_GS_COMPUTER_SYSTEM LEFT OUTER JOIN
v_GS_OPERATING_SYSTEM ON v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_OPERATING_SYSTEM.ResourceID
ORDER BY v_GS_COMPUTER_SYSTEM.ResourceID