SCCM help

Andybtsn · 12 May 2015 at 15:36

Hi guys,

We implemented SCCM 2012 a few months ago and apart from a few app deployments and Windows update installs it's not been overly used.

My manager wants to know how many SSD's are on site in computers, how do I go about finding this info? Noob guide please!

I assume I have to do a device collection then a query?

Deleted member 77746 · 12 May 2015 at 15:47

Are all the models of SSD the same or different in each system?

EDIT
You may be able to do it with something using the PNPDeviceID query.

For example.
" SMS_G_System_DISK.PNPDeviceID "

Code:

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client 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.PNPDeviceID like IDE\\DISKINTEL_SSD%

Andybtsn · 12 May 2015 at 15:56

A lot of the SSD's are different but also there are only about 100 of the 850 odd PC's we have on site, it's my jobs to find the specific ones.

Reporting isn#t the best way to go in Monitoring?

Deleted member 77746 · 12 May 2015 at 15:58

Andybtsn said:
A lot of the SSD's are different but also there are only about 100 of the 850 odd PC's we have on site, it's my jobs to find the specific ones.

Reporting isn#t the best way to go in Monitoring?

http://www.windows-noob.com/forums/...all-workstation-computers-hardware-inventory/

This SCCM report might work a treat! Hopefully will pull in HDD info and you should be able to search for specific models.

Do you not run any remote inventory software?

Andybtsn · 12 May 2015 at 16:29

Thanks although I have no idea what to do with that query...creating a new report and editing it in SQL is something I haven't done before.