Skip to content

Instantly share code, notes, and snippets.

@vexx32
Created June 27, 2018 13:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save vexx32/8dea21963497f45356a47832f6b82fbf to your computer and use it in GitHub Desktop.
Save vexx32/8dea21963497f45356a47832f6b82fbf to your computer and use it in GitHub Desktop.
$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