powershell script to notify if any of the disk goes offline

Question

Hi All, I am trying to prepare a script to notify me if one of the disks goes offline. I plan to create this as a SQL job so that the job fails when any of the disks is not accessible. The below variable has the list of drives on the server and I want to the PowerShell test-path command against each value, but I am unable to write code for the same. Any help would be greatly appreciated. $DriveList = @(Invoke-SQLCmd -query "select distinct LEFT(physical_name, 3) from sys.master_files") test-path $DriveList

Thanks in Advance!

Answer 1

If you're just looking for a PowerShell script that runs in loop forever, is this what you're looking for?

$Drives = "C:\", "X:\"
Do{
    $drives | 
        ForEach-Object {
            if (-NOT (test-path $_)){
                Throw "Path $_ is no longer available"
            }
        }
        Start-Sleep -Seconds 5
} while ($true)