PowerTip: Using Parameters with the Get-WmiObject PowerShell Cmdlet

re: PowerTip: Using Parameters with the Get-WmiObject PowerShell Cmdlet

CoolDBA — Fri, 14 Sep 2012 16:53:08 GMT

I am trying to retrieve the disk usage information for the list of SQL servers(a,b,c,d....) using following command

$serverlist = get-content 'D:\APPS\Serverlist.txt'

foreach($server in $serverlist)

{

Get-WmiObject Win32_Volume -ComputerName $server | Select-Object SystemName,Label,Name,DriveLetter,DriveType,Capacity,Freespace

}

For 4 weeks it executed fine and generated the disk usage report for all the servers.

but suddenly it started generating error for one of the server as shown below:

Get-WmiObject : Provider load failure

At line:1 char:14

+ Get-WmiObject <<<< Win32_Volume -ComputerName 'd' | Select-Object SystemName,Label,Name,DriveLetter,DriveType,Capacity,Freespace

+ CategoryInfo : InvalidOperation: (:) [Get-WmiObject], ManagementException

+ FullyQualifiedErrorId : GetWMIManagementException,Microsoft.PowerShell.Commands.GetWmiObjectCommand

I was not able to find any answer on web for this error. Whatever is available is only for Win32_Reliability , not for Win32_Volume.

Does anybody faced such kind of issue ?

Please help me resolving this issue.

Ed WIlson — Fri, 10 Aug 2012 16:43:30 GMT

@RLToscano you are welcome. I am glad you enjoy it.

@JRV you are right ... glad you like the tip

@K_Schulte you are correct. I LOVE WMI ... especially the way that PowerShell exposes WMI.

K_Schulte — Fri, 10 Aug 2012 06:59:58 GMT

GWMI rocks :-)

Klaus.

jrv — Thu, 09 Aug 2012 20:48:36 GMT

Excellent. Iti s the 'propewrty" parameter that allows us to programmticale select the properties very easily.

$props='name','version'

$props[0]

$props[1]

Get-WmiObject win32_bios -Property $props|select -expand properties|select name,value|ft -auto

RLToscano — Thu, 09 Aug 2012 20:43:29 GMT

Thx for the nice tip!