NEW Query like Disk Part Number

[Pros]

Hello
I would need your help to request under SCCM.
I wanted to display the list of laptops whose SSD Part Number is for example "XXXXX-XXX-XXX".
Would you have an idea of a solution to help me?

Thanks in advance for your help

 

[Garth]

Hello
I would need your help to request under SCCM.
I wanted to display the list of laptops whose SSD Part Number is for example "XXXXX-XXX-XXX".
Would you have an idea of a solution to help me?

Thanks in advance for your help

Where in SCCM do you see the part number of the SSD? Or where on the computer do you see this p[art number?

 

[Pros]

Where in SCCM do you see the part number of the SSD? Or where on the computer do you see this p[art number?

Hello,
Thank you for your feedback,
When I look at the disk information with "msinfo32", I can't find the Part number, no the Manufacturer.
On the other hand I have the Model of the disk which is the same for some laptops.
Would it be possible to have the list of laptops having the same disk model?
Thank you in advance,
with regards to this matter,

 

[Garth]

Hello,
Thank you for your feedback,
When I look at the disk information with "msinfo32", I can't find the Part number, no the Manufacturer.
On the other hand I have the Model of the disk which is the same for some laptops.
Would it be possible to have the list of laptops having the same disk model?
Thank you in advance,
with regards to this matter,

View attachment 5264

Have you looked at the data within Resource Explorer for SCCM?

 

[Pros]

Have you looked at the data within Resource Explorer for SCCM?

Good evening,
The disk model is in the Resource Explorer data.
But I don't see how to build the query to list the names of the machines with model SSDPR-PX500-512-80
--- Can I have a query like this
Select SMS_R_System.Name, SMS_R_System_Disk_Drive.Model
From SMS_R_System
Where SMS_RSystem_Disk_Drive.Model = "SSDPR-PX500-512-80"
Order by SMS_R_System.Name

Thanks

 

[Hackmuss]

You need to create a join for the two views you are querying. Try this:
select SMS_R_System.Name, SMS_G_System_DISK.Model from SMS_R_System inner join SMS_G_System_DISK on SMS_G_System_DISK.ResourceID = SMS_R_System.ResourceId where SMS_G_System_DISK.Model = "SSDPR-PX500-512-80" order by SMS_R_System.Name

 

[Pros]

You need to create a join for the two views you are querying. Try this:
select SMS_R_System.Name, SMS_G_System_DISK.Model from SMS_R_System inner join SMS_G_System_DISK on SMS_G_System_DISK.ResourceID = SMS_R_System.ResourceId where SMS_G_System_DISK.Model = "SSDPR-PX500-512-80" order by SMS_R_System.Name

Hello,
Thank you very much, it's working very well.
Sincerely