Skip to content

Instantly share code, notes, and snippets.

@martin9700

martin9700/Set-CellColor.ps1

Created February 27, 2014 14:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save martin9700/9251658 to your computer and use it in GitHub Desktop.
Save martin9700/9251658 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Set-CellColor.ps1
$Data = @"
"Server","Path","CookedValue"
"dc","\\dc\\memory\available mbytes","1377"
"dc2","\\dc2\\memory\available mbytes","70"
"dc2","\\dc2\\processor(_total)\% processor time","0.00190904948765835"
"dc","\\dc\\processor(_total)\% processor time","0.000565369831695417"
"dc2","\\dc2\\system\processor queue length","0"
"dc2","\\dc2\\processor(_total)\% privileged time","0"
"dc2","\\dc2\\memory\pages/sec","0"
"dc","\\dc\\memory\pages/sec","0"
"dc","\\dc\\processor(_total)\% privileged time","0"
"dc","\\dc\\system\processor queue length","0"
"@
$Data = $Data | ConvertFrom-Csv
$Header = @"
<style>
TABLE {border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}
TH {border-width: 1px;padding: 3px;border-style: solid;border-color: black;background-color: #6495ED;}
TD {border-width: 1px;padding: 3px;border-style: solid;border-color: black;}
</style>
"@
$HTML = $Data | sort server | ConvertTo-html -head $header | Set-CellColor -Property cookedvalue -Color red -Filter "cookedvalue -gt 90"
$HTML = $HTML | Set-CellColor Server green -Filter "server -eq 'dc2'"
$HTML | Set-CellColor Path Yellow -Filter "Path -like ""*memory*""" | Out-File c:\Test\colortest.html
& c:\Test\colortest.html
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment