One comment

  1. 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:APPSServerlist.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 generating 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 , nut not for Win32_Volume.
    Does anybody faced such kind of issue ?
    Please help me resolving this issue.

    coolDBA Beantwoorden