SCCM SQL Query for SSD Drives

Published December 05, 2013 by FoxDeploy

Recently at a client, a need arose to provide a report listing whether a workstation had an SSD or a spinning disk.

Unfortunately, Windows does not concern itself with noting whether or not a disk is spinning or solid state, and thus the information is not in the registry or WMI for us to collect with SCCM.

However, most manufacturers stick to a naming convention, and with a little bit of elbow grease, you can expand this to work in your environment too.  In this format, you’ll get ‘Known SSD Drive’ if the drive model or naming is captured in the CASE filter of query, or the drive model if not.

Jump here for the code : Detect SSD Drive

Microsoft MVP

Five time Microsoft MVP, and now I work for the mothership

Need Help?

Get help much faster on our new dedicated Subreddit!

depicts a crowd of people in a night club with colored lights and says 'join the foxdeploy subrreddit today'

Blog Series
series_sml_PowerShellGUI series_sml_IntroToRaspberryPi Programming series_sml_IntroToWindows Remote Management Series The Logo for System Center Configuration Manager is displayed here Depicts a road sign saying 'Learning PowerShell Autocomplete'

Blog Stats