Created
June 27, 2018 13:12
-
-
Save vexx32/8dea21963497f45356a47832f6b82fbf to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$Data = Invoke-MySQLQuery -ComputerName k1000 -Credential $creds -Query $sql -Database ORG1 | | |
Where-Object DISK_NAME -MATCH 'Drive C:' | | |
ForEach-Object { | |
[PSCustomObject]@{ | |
'Computer Name' = $_.System_Name | |
'Percent Used' = $_.Percent_Used | |
'Disk Free' = $_.Disk_Free | |
'Disk Name' = $_.Disk_Name | |
'Disk Size' = $_.Disk_Size | |
'Disk Used' = $_.Disk_Used | |
} | |
} | Sort-Object 'Disk Used' -Descending |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment