Overclock.net › Forums › Specialty Builds › Servers › WMI Query for SSD?
New Posts  All Forums:Forum Nav:

WMI Query for SSD?

post #1 of 4
Thread Starter 
Does anyone know a WMI query that can tell if a PC has an SSD for %systemdrive%? I want to filter a GPO to just PCs with SSDs automatically.
Server
(11 items)
 
  
CPUMotherboardRAMHard Drive
Intel Core i5-3470 ASRock Z77 Extreme6 16 GB G.Skill Sniper DDR3-1600 1TB WD Caviar Black 
Hard DriveCoolingOSCase
4TB WD Caviar Red Cooler Master Hyper 212+ VMWare ESXi NZXT Crafted Series Tempest 410 
OtherOtherOther
LSI 9280-16i4e RAID Card Intel I350 Quad Port Gigabit NIC Intel Pro/1000 PT Dual Port Gigabit NIC 
  hide details  
Reply
Server
(11 items)
 
  
CPUMotherboardRAMHard Drive
Intel Core i5-3470 ASRock Z77 Extreme6 16 GB G.Skill Sniper DDR3-1600 1TB WD Caviar Black 
Hard DriveCoolingOSCase
4TB WD Caviar Red Cooler Master Hyper 212+ VMWare ESXi NZXT Crafted Series Tempest 410 
OtherOtherOther
LSI 9280-16i4e RAID Card Intel I350 Quad Port Gigabit NIC Intel Pro/1000 PT Dual Port Gigabit NIC 
  hide details  
Reply
post #2 of 4
From my previous research and testing, nothing in WMI shows if a drive is SSD or HDD. You can find the interface type, but that doesn't help.

For example, if I run:
wmic diskdrive list brief (Powershell or CMD)

It returns this:
Code:
Caption                                DeviceID            Model                                  Partitions  Size

AMD 2+0 Stripe/RAID0 SCSI Disk Device  \\.\PHYSICALDRIVE0  AMD 2+0 Stripe/RAID0 SCSI Disk Device  2           117999866880

(I have 2 60GB Mushkin Enhanced Chronos Deluxe in Raid0)

AMD because it's using the AMD onboard controller, 2+0 because it's 2 drives with 0 spares, stripe/Raid0...because it's Raid0. Why it shows up SCSI, I do not know. I'd assume it has something to do with my Raid. Lastly, there is nothing directly tying it to my boot drive (you would have to do some post query processing to get this info).

For example, if I run:
wmic diskdrive list full

It returns:
Code:
Availability=
BytesPerSector=512
Capabilities={3,4}
CapabilityDescriptions={"Random Access","Supports Writing"}
CompressionMethod=
ConfigManagerErrorCode=0
ConfigManagerUserConfig=FALSE
DefaultBlockSize=
Description=Disk drive
DeviceID=\\.\PHYSICALDRIVE0
ErrorCleared=
ErrorDescription=
ErrorMethodology=
Index=0
InstallDate=
InterfaceType=SCSI
LastErrorCode=
Manufacturer=(Standard disk drives)
MaxBlockSize=
MaxMediaSize=
MediaLoaded=TRUE
MediaType=Fixed hard disk media
MinBlockSize=
Model=AMD 2+0 Stripe/RAID0 SCSI Disk Device
Name=\\.\PHYSICALDRIVE0
NeedsCleaning=
NumberOfMediaSupported=
Partitions=2
PNPDeviceID=SCSI\DISK&VEN_AMD&PROD_2+0_STRIPE/RAID0\4&AEB806D&0&000000
PowerManagementCapabilities=
PowerManagementSupported=
SCSIBus=0
SCSILogicalUnit=0
SCSIPort=4
SCSITargetId=0
SectorsPerTrack=63
Signature=3737494951
Size=117999866880
Status=OK
StatusInfo=
SystemName=DEREKDESKTOP
TotalCylinders=14346
TotalHeads=255
TotalSectors=230468490
TotalTracks=3658230
TracksPerCylinder=255

The full command shows the PNP dev_ and ven_ IDs, but where I am in raid it doesn't list it that way. Also, disappointing, is that it doesn't list my individual drives...just my array.

Play around with this, in case you haven't used a WMI GUI before:
http://thepowershellguy.com/blogs/posh/archive/2007/03/22/powershell-wmi-explorer-part-1.aspx

A great tool. NameSpace you want is ROOT\CIMV2, and class should be Win32_DiskDrive.

Lastly, I am a SCCM (SMS or ConfigMgr, whichever you have heard before) guy...so let me check around in reporting with my home environment, and see if it can do anything better.
post #3 of 4
Thread Starter 
Yeah I didn't know of and couldn't find anything either....I thought maybe there was something I missed. I mean, Windows does some testing to detect an SSD to know if it should run defrag, right? Is there a query for that info? Or maybe a registry key?

I was about to resort to using the Model since there's only one type of SSD used in this company, but it would be nice to have something generic that I don't have to worry about.

Thanks for the GUI too, never tried one before.
Server
(11 items)
 
  
CPUMotherboardRAMHard Drive
Intel Core i5-3470 ASRock Z77 Extreme6 16 GB G.Skill Sniper DDR3-1600 1TB WD Caviar Black 
Hard DriveCoolingOSCase
4TB WD Caviar Red Cooler Master Hyper 212+ VMWare ESXi NZXT Crafted Series Tempest 410 
OtherOtherOther
LSI 9280-16i4e RAID Card Intel I350 Quad Port Gigabit NIC Intel Pro/1000 PT Dual Port Gigabit NIC 
  hide details  
Reply
Server
(11 items)
 
  
CPUMotherboardRAMHard Drive
Intel Core i5-3470 ASRock Z77 Extreme6 16 GB G.Skill Sniper DDR3-1600 1TB WD Caviar Black 
Hard DriveCoolingOSCase
4TB WD Caviar Red Cooler Master Hyper 212+ VMWare ESXi NZXT Crafted Series Tempest 410 
OtherOtherOther
LSI 9280-16i4e RAID Card Intel I350 Quad Port Gigabit NIC Intel Pro/1000 PT Dual Port Gigabit NIC 
  hide details  
Reply
post #4 of 4
I haven't done any research on WMI querying for an SSD but I did get really in WMI queries for a few months there and I was just thinking about it...maybe there's an indirect way to tell something like that...?

Like perhaps all SSDs score higher on the WEI than any mechanical or...maybe there's a writes/second or related stat stored some place...I'm really thinking about getting an SSD thumb.gif
 
VM Server
(17 items)
 
 
CPUGraphicsRAMHard Drive
Intel Ivy Bridge Core i7-3630QM nVidia GeForce GTX 680M 16GB DDR3 1600MHz Dual Channel Memory (2 SODIMMS) Hard Drive: Serial-ATA II 3GB/s 
Hard DriveOSMonitorPower
Hard Drive: Serial-ATA II 3GB/s Windows 10 Pro x64 17.3" FHD 16:9 (1920x1080) Battery: Smart Li-ion Battery (8-Cell) 
Audio
Sound Blaster Compatible 3D Audio 
CPUMotherboardGraphicsRAM
Intel Core i7 860 Biostar T5 XE Radeon HD 5870 Corsair 16GB  
Hard DriveHard DriveOptical DriveOS
Western Digital hard drive wd1001fals-00e8b0 Maxtor 300GB I don't need no stinking optical drive Microsoft Windows 7 Ultimate x64 
MonitorMonitorKeyboardPower
HP ZR24w 24'' Samsung SyncMaster 24" logitech wireless k360 Seventeam ST-850ZAF 850W ATX 
CaseMouseAudioAudio
Thermaltake V9 Black Edition Logitech G500 Programmable Gaming Mouse FiiO E7 USB DAC and Portable Headphone Amplifier Sennheiser HD555 Professional Headphones 
  hide details  
Reply
 
VM Server
(17 items)
 
 
CPUGraphicsRAMHard Drive
Intel Ivy Bridge Core i7-3630QM nVidia GeForce GTX 680M 16GB DDR3 1600MHz Dual Channel Memory (2 SODIMMS) Hard Drive: Serial-ATA II 3GB/s 
Hard DriveOSMonitorPower
Hard Drive: Serial-ATA II 3GB/s Windows 10 Pro x64 17.3" FHD 16:9 (1920x1080) Battery: Smart Li-ion Battery (8-Cell) 
Audio
Sound Blaster Compatible 3D Audio 
CPUMotherboardGraphicsRAM
Intel Core i7 860 Biostar T5 XE Radeon HD 5870 Corsair 16GB  
Hard DriveHard DriveOptical DriveOS
Western Digital hard drive wd1001fals-00e8b0 Maxtor 300GB I don't need no stinking optical drive Microsoft Windows 7 Ultimate x64 
MonitorMonitorKeyboardPower
HP ZR24w 24'' Samsung SyncMaster 24" logitech wireless k360 Seventeam ST-850ZAF 850W ATX 
CaseMouseAudioAudio
Thermaltake V9 Black Edition Logitech G500 Programmable Gaming Mouse FiiO E7 USB DAC and Portable Headphone Amplifier Sennheiser HD555 Professional Headphones 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Servers
Overclock.net › Forums › Specialty Builds › Servers › WMI Query for SSD?