{"id":4491,"date":"2016-09-08T06:00:59","date_gmt":"2016-09-08T14:00:59","guid":{"rendered":"https:\/\/www.atumvirt.com\/?p=4491"},"modified":"2016-09-08T06:00:59","modified_gmt":"2016-09-08T14:00:59","slug":"checking-the-percentage-of-desktops-available-in-each-xendesktop-site","status":"publish","type":"post","link":"https:\/\/avtempwp.azurewebsites.net\/2016\/09\/checking-the-percentage-of-desktops-available-in-each-xendesktop-site\/","title":{"rendered":"[Script] Checking the Percentage of Desktops Available in Each XenDesktop Site"},"content":{"rendered":"<p>When you manage multiple sites you may find that Citrix Director lacks an \u201cat-a-glance\u201d view of the status of multiple sites. This becomes extra apparent in a large pod-based design where multiple sites may exist within the same datacenter or in an active-active datacenter setup. With VDI, it is important to check the total number of VM\u2019s that are available for brokering. If the number is too low, you could be faced with a boot storm (assuming you have powered off virtual machines) if a large number of users log in. Or worse, you may not have available capacity. It is important to catch such incidents before they happen. Therefore, I present to you a script to output a simple HTML formatted table that can be incorporated into existing monitoring dashboards or sites (such as SharePoint).<\/p>\n<p><a href=\"\/wp-content\/uploads\/2016\/09\/clip_image001.png\"><img loading=\"lazy\" style=\"display: inline; background-image: none;\" title=\"clip_image001\" src=\"\/wp-content\/uploads\/2016\/09\/clip_image001_thumb.png\" alt=\"clip_image001\" width=\"244\" height=\"166\" border=\"0\" \/><\/a><\/p>\n<p>Figure 1 Sample table output from script<\/p>\n<pre lang=\"PowerShell\">\u00a0\u00a0 <#\n\u00a0\u00a0\u00a0 .SYNOPSIS\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Generates a report from multiple XenDesktop sites showing desktops available.\n\u00a0\u00a0\u00a0 .DESCRIPTION\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Monitoring multiple sites can require multiple checks to ensure each is`\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 in proper running order.\u00a0 This script will determine the percentage of`\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 desktops available and display an HTML formatted table to provide an `\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 quick summary for an administrator.\n\u00a0\u00a0\u00a0 .PARAMETER SitesToMonitor\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 A collection of strings with delivery controller addresses\n\u00a0\u00a0\u00a0 .PARAMETER WarningThreshold\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 When the value falls below this number, cells in the report will be highlighted\n\u00a0\u00a0\u00a0 .PARAMETER Interactive\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Enable this switch to load the file after generation\n\u00a0\u00a0\u00a0 .EXAMPLE\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 .\\CheckDesktopsAvailable.ps1 -SitesToMonitor \"site1.contoso.local\",\"site2.contoso.local\" -OutputPath \"C:\\temp\\report.html\"\n\u00a0\u00a0\u00a0 .EXAMPLE\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 .\\CheckDesktopsAvailable.ps1 -SitesToMonitor \"site1.contoso.local\",\"site2.contoso.local\"\u00a0 -OutputPath \"C:\\temp\\report.html\" -WarningThreshold 15 \n\u00a0\u00a0\u00a0 .EXAMPLE\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 .\\CheckDesktopsAvailable.ps1 -SitesToMonitor \"site1.contoso.local\",\"site2.contoso.local\"\u00a0 -OutputPath \"C:\\temp\\report.html\" -WarningThreshold 15 -Interactive\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \n\u00a0\u00a0\u00a0 .NOTES\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Author:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Preston Gallwas (functions credited)\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Twitter:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 @AtumVirt\n\u00a0\u00a0\u00a0 .LINK\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 http:\/\/www.atumvirt.com\n\u00a0\u00a0\u00a0 #>\n\n\n\u00a0\u00a0\u00a0 [CmdletBinding()]\n\u00a0\u00a0\u00a0 Param (\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [Parameter(Mandatory,Position=0,ValueFromPipeline)]\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [string[]]$SitesToMonitor,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [Parameter(Mandatory,Position=1)]\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [string]$OutputPath,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [Parameter(Position=2)]\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [int]$WarningThreshold=15,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [Parameter(Position=3)]\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [switch]$Interactive\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 )\n\nAsnp Citrix*\nFunction Set-AlternatingRows {\n\u00a0<#\n\u00a0.SYNOPSIS\n\u00a0\u00a0Simple function to alternate the row colors in an HTML table\n\u00a0.DESCRIPTION\n\u00a0\u00a0This function accepts pipeline input from ConvertTo-HTML or any\n\u00a0\u00a0string with HTML in it.\u00a0 It will then search for <tr> and replace \n\u00a0\u00a0it with <tr class=(something)>.\u00a0 With the combination of CSS it\n\u00a0\u00a0can set alternating colors on table rows.\n\u00a0\u00a0\n\u00a0\u00a0CSS requirements:\n\u00a0\u00a0.odd { background-color:#ffffff; }\n\u00a0\u00a0.even { background-color:#dddddd; }\n\u00a0\u00a0\n\u00a0\u00a0Classnames can be anything and are configurable when executing the\n\u00a0\u00a0function.\u00a0 Colors can, of course, be set to your preference.\n\u00a0\u00a0\n\u00a0\u00a0This function does not add CSS to your report, so you must provide\n\u00a0\u00a0the style sheet, typically part of the ConvertTo-HTML cmdlet using\n\u00a0\u00a0the -Head parameter.\n\u00a0.PARAMETER Line\n\u00a0\u00a0String containing the HTML line, typically piped in through the\n\u00a0\u00a0pipeline.\n\u00a0.PARAMETER CSSEvenClass\n\u00a0\u00a0Define which CSS class is your \"even\" row and color.\n\u00a0.PARAMETER CSSOddClass\n\u00a0\u00a0Define which CSS class is your \"odd\" row and color.\n\u00a0.EXAMPLE $Report | ConvertTo-HTML -Head $Header | Set-AlternateRows -CSSEvenClass even -CSSOddClass odd | Out-File HTMLReport.html\n\u00a0\n\u00a0\u00a0$Header can be defined with a here-string as:\n\u00a0\u00a0$Header = @\"\n\u00a0\u00a0<style>\n\u00a0\u00a0TABLE {border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}\n\u00a0\u00a0TH {border-width: 1px;padding: 3px;border-style: solid;border-color: black;background-color: #6495ED;}\n\u00a0\u00a0TD {border-width: 1px;padding: 3px;border-style: solid;border-color: black;}\n\u00a0\u00a0.odd\u00a0 { background-color:#ffffff; }\n\u00a0\u00a0.even { background-color:#dddddd; }\n\u00a0<\/style>\n\u00a0\u00a0\"@\n\u00a0\u00a0\n\u00a0\u00a0This will produce a table with alternating white and grey rows.\u00a0 Custom CSS\n\u00a0\u00a0is defined in the $Header string and included with the table thanks to the -Head\n\u00a0\u00a0parameter in ConvertTo-HTML.\n\u00a0.NOTES\n\u00a0\u00a0Author:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Martin Pugh\n\u00a0\u00a0Twitter:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 @thesurlyadm1n\n\u00a0\u00a0Spiceworks:\u00a0\u00a0\u00a0\u00a0 Martin9700\n\u00a0\u00a0Blog:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 www.thesurlyadmin.com\n\u00a0\u00a0\n\u00a0\u00a0Changelog:\n\u00a0\u00a0 1.1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Modified replace to include the <td> tag, as it was changing the class\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 for the TH row as well.\n   1.0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Initial function release\n\u00a0.LINK\n\u00a0\u00a0http:\/\/community.spiceworks.com\/scripts\/show\/1745-set-alternatingrows-function-modify-your-html-table-to-have-alternating-row-colors\n\u00a0\u00a0\u00a0 .LINK\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 http:\/\/thesurlyadmin.com\/2013\/01\/21\/how-to-create-html-reports\/\n\u00a0#>\n\u00a0\u00a0\u00a0 [CmdletBinding()]\n\u00a0\u00a0 \u00a0Param(\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0[Parameter(Mandatory,ValueFromPipeline)]\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [string]$Line,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \n\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0 [Parameter(Mandatory)]\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0[string]$CSSEvenClass,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [Parameter(Mandatory)]\n\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0 [string]$CSSOddClass\n\u00a0\u00a0 \u00a0)\n\u00a0Begin {\n\u00a0\u00a0$ClassName = $CSSEvenClass\n\u00a0}\n\u00a0Process {\n\u00a0\u00a0If ($Line.Contains(\"<tr><td>\"))\n\u00a0\u00a0{\u00a0$Line = $Line.Replace(\"<tr>\",\"<tr class=\"\"$ClassName\"\">\")\n\u00a0\u00a0\u00a0If ($ClassName -eq $CSSEvenClass)\n\u00a0\u00a0\u00a0{\u00a0$ClassName = $CSSOddClass\n\u00a0\u00a0\u00a0}\n\u00a0\u00a0\u00a0Else\n\u00a0\u00a0\u00a0{\u00a0$ClassName = $CSSEvenClass\n\u00a0\u00a0\u00a0}\n\u00a0\u00a0}\n\u00a0\u00a0Return $Line\n\u00a0}\n}\nFunction Set-CellColor{\n\u00a0\u00a0 <#\n\u00a0\u00a0\u00a0 .SYNOPSIS\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Function that allows you to set individual cell colors in an HTML table\n\u00a0\u00a0\u00a0 .DESCRIPTION\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 To be used inconjunction with ConvertTo-HTML this simple function allows you\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 to set particular colors for cells in an HTML table.\u00a0 You provide the criteria\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 the script uses to make the determination if a cell should be a particular \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 color (property -gt 5, property -like \"*Apple*\", etc).\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 You can add the function to your scripts, dot source it to load into your current\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PowerShell session or add it to your $Profile so it is always available.\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 To dot source:\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 .\".\\Set-CellColor.ps1\"\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \n\u00a0\u00a0\u00a0 .PARAMETER Property\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Property, or column that you will be keying on.\u00a0 \n\u00a0\u00a0\u00a0 .PARAMETER Color\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Name or 6-digit hex value of the color you want the cell to be\n\u00a0\u00a0\u00a0 .PARAMETER InputObject\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 HTML you want the script to process.\u00a0 This can be entered directly into the\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 parameter or piped to the function.\n\u00a0\u00a0\u00a0 .PARAMETER Filter\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Specifies a query to determine if a cell should have its color changed.\u00a0 $true\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 results will make the color change while $false result will return nothing.\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Syntax\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Property Name> <Operator> <Value>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Property Name>::= the same as $Property.\u00a0 This must match exactly\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Operator>::= \"-eq\" | \"-le\" | \"-ge\" | \"-ne\" | \"-lt\" | \"-gt\"| \"-approx\" | \"-like\" | \"-notlike\" \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <JoinOperator> ::= \"-and\" | \"-or\"\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <NotOperator> ::= \"-not\"\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 The script first attempts to convert the cell to a number, and if it fails it will\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 cast it as a string.\u00a0 So 40 will be a number and you can use -lt, -gt, etc.\u00a0 But 40%\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 would be cast as a string so you could only use -eq, -ne, -like, etc.\u00a0 \n\u00a0\u00a0\u00a0 .PARAMETER Row\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Instructs the script to change the entire row to the specified color instead of the individual cell.\n\u00a0\u00a0\u00a0 .INPUTS\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 HTML with table\n\u00a0\u00a0\u00a0 .OUTPUTS\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 HTML\n\u00a0\u00a0\u00a0 .EXAMPLE\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 get-process | convertto-html | set-cellcolor -Propety cpu -Color red -Filter \"cpu -gt 1000\" | out-file c:\\test\\get-process.html\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Assuming Set-CellColor has been dot sourced, run Get-Process and convert to HTML.\u00a0 \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Then change the CPU cell to red only if the CPU field is greater than 1000.\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \n\u00a0\u00a0\u00a0 .EXAMPLE\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 get-process | convertto-html | set-cellcolor cpu red -filter \"cpu -gt 1000 -and cpu -lt 2000\" | out-file c:\\test\\get-process.html\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Same as Example 1, but now we will only turn a cell red if CPU is greater than 100 \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 but less than 2000.\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \n\u00a0\u00a0\u00a0 .EXAMPLE\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $HTML = $Data | sort server | ConvertTo-html -head $header | Set-CellColor cookedvalue red -Filter \"cookedvalue -gt 1\"\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PS C:\\> $HTML = $HTML | Set-CellColor Server green -Filter \"server -eq 'dc2'\"\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PS C:\\> $HTML | Set-CellColor Path Yellow -Filter \"Path -like \"\"*memory*\"\"\" | Out-File c:\\Test\\colortest.html\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Takes a collection of objects in $Data, sorts on the property Server and converts to HTML.\u00a0 From there \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 we set the \"CookedValue\" property to red if it's greater then 1.\u00a0 We then send the HTML through Set-CellColor\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 again, this time setting the Server cell to green if it's \"dc2\".\u00a0 One more time through Set-CellColor\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 turns the Path cell to Yellow if it contains the word \"memory\" in it.\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \n\u00a0\u00a0\u00a0 .EXAMPLE\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $HTML = $Data | sort server | ConvertTo-html -head $header | Set-CellColor cookedvalue red -Filter \"cookedvalue -gt 1\" -Row\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Now, if the cookedvalue property is greater than 1 the function will highlight the entire row red.\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \n\u00a0\u00a0\u00a0 .NOTES\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Author:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Martin Pugh\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Twitter:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 @thesurlyadm1n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Spiceworks:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Martin9700\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Blog:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 www.thesurlyadmin.com\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Changelog:\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.5 Added ability to set row color with -Row switch instead of the individual cell\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.03 Added error message in case the $Property field cannot be found in the table header\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.02\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Added some additional text to help.\u00a0 Added some error trapping around $Filter\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 creation.\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.01 Added verbose output\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.0 Initial Release\n\u00a0\u00a0\u00a0 .LINK\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 http:\/\/community.spiceworks.com\/scripts\/show\/2450-change-cell-color-in-html-table-with-powershell-set-cellcolor\n\u00a0\u00a0\u00a0 #>\n\n\u00a0\u00a0\u00a0 [CmdletBinding()]\n\u00a0\u00a0\u00a0 Param (\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [Parameter(Mandatory,Position=0)]\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [string]$Property,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [Parameter(Mandatory,Position=1)]\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [string]$Color,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [Parameter(Mandatory,ValueFromPipeline)]\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [Object[]]$InputObject,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [Parameter(Mandatory)]\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [string]$Filter,\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [switch]$Row\n\u00a0\u00a0\u00a0 )\n\u00a0\u00a0\u00a0 \n\u00a0\u00a0\u00a0 Begin {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write-Verbose \"$(Get-Date): Function Set-CellColor begins\"\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 If ($Filter)\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\u00a0\u00a0 If ($Filter.ToUpper().IndexOf($Property.ToUpper()) -ge 0)\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\u00a0\u00a0 $Filter = $Filter.ToUpper().Replace($Property.ToUpper(),\"`$Value\")\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Try {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [scriptblock]$Filter = [scriptblock]::Create($Filter)\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Catch {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write-Warning \"$(Get-Date): \"\"$Filter\"\" caused an error, stopping script!\"\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write-Warning $Error[0]\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Exit\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Else\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\u00a0\u00a0 Write-Warning \"Could not locate $Property in the Filter, which is required.\u00a0 Filter: $Filter\"\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Exit\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0 \n\u00a0\u00a0\u00a0 Process {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ForEach ($Line in $InputObject)\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\u00a0\u00a0 If ($Line.IndexOf(\"<tr><th\") -ge 0)\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\u00a0\u00a0 Write-Verbose \"$(Get-Date): Processing headers...\"\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $Search = $Line | Select-String -Pattern '<th ?[a-z\\-:;\"=]*>(.*?)<\\\/th>' -AllMatches\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $Index = 0\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ForEach ($Match in $Search.Matches)\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\u00a0\u00a0 If ($Match.Groups[1].Value -eq $Property)\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\u00a0\u00a0 Break\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $Index ++\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 If ($Index -eq $Search.Matches.Count)\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\u00a0\u00a0 Write-Warning \"$(Get-Date): Unable to locate property: $Property in table header\"\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Exit\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write-Verbose \"$(Get-Date): $Property column found at index: $Index\"\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 If ($Line -match \"<tr( style=\"\"background-color:.+?\"\")?><td\")\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\u00a0\u00a0 $Search = $Line | Select-String -Pattern '<td ?[a-z\\-:;\"=]*>(.*?)<\\\/td>' -AllMatches\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $Value = $Search.Matches[$Index].Groups[1].Value -as [double]\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 If (-not $Value)\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\u00a0\u00a0 $Value = $Search.Matches[$Index].Groups[1].Value\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 If (Invoke-Command $Filter)\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\u00a0\u00a0 If ($Row)\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\u00a0\u00a0 Write-Verbose \"$(Get-Date): Criteria met!\u00a0 Changing row to $Color...\"\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 If ($Line -match \"<tr style=\"\"background-color:(.+?)\"\">\")\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\u00a0\u00a0 $Line = $Line -replace \"<tr style=\"\"background-color:$($Matches[1])\",\"<tr style=\"\"background-color:$Color\"\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Else\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\u00a0\u00a0 $Line = $Line.Replace(\"<tr>\",\"<tr style=\"\"background-color:$Color\"\">\")\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Else\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\u00a0\u00a0 Write-Verbose \"$(Get-Date): Criteria met!\u00a0 Changing cell to $Color...\"\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $Line = $Line.Replace($Search.Matches[$Index].Value,\"<td style=\"\"background-color:$Color\"\">$Value<\/td>\")\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write-Output $Line\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0 \n\u00a0\u00a0\u00a0 End {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write-Verbose \"$(Get-Date): Function Set-CellColor completed\"\n\u00a0\u00a0\u00a0 }\n}\nfunction AddDesktopsAvailablePercent {\n[CmdletBinding()]\n\u00a0\u00a0 \u00a0Param(\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0[Parameter(Mandatory,ValueFromPipeline)]\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $Input\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 )\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 try {\u00a0 $val=$($Input.DesktopsAvailable\/$Input.totalDesktops) }\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 catch { $val=0 }\n\u00a0\u00a0 \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $per=[Math]::Truncate($val*100)\n\n\u00a0\u00a0\u00a0 $Input | Add-Member -NotePropertyName \"DesktopsAvailablePercent\" -NotePropertyValue $per\n\n}\n\n\n\n\n$Header = @\"\n<style> \n\u00a0TABLE {border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;} \n\u00a0TH {border-width: 1px;padding: 3px;border-style: solid;border-color: black;background-color: #6495ED;} \n\u00a0TD {border-width: 1px;padding: 3px;border-style: solid;border-color: black;} \n\u00a0.odd { background-color:#ffffff; } \n\u00a0.even { background-color:#dddddd; } \n<\/style>\n\"@\n\n$dgs=@()\nforeach ($siteAddress in $SitesToMonitor)\n{\n\u00a0$dgs+=Get-BrokerDesktopGroup -AdminAddress $siteAddress\n}\n\n\nforeach($group in $dgs)\n{\n\u00a0$group | AddDesktopsAvailablePercent\n}\n\n$output= $dgs | select name,desktopsavailable, TotalDesktops,InMaintenanceMode,DesktopsAvailablePercent | ConvertTo-HTML -head $header -body \"<H2>Desktops Available - Warning at $($WarningThreshold)<\/H2>\" | `\nset-cellcolor InMaintenanceMode yellow -filter \"InMaintenanceMode -eq 'True'\"\u00a0 `\n| set-cellcolor DesktopsAvailablePercent red -filter \"DesktopsAvailablePercent -lt $($WarningThreshold)\" `\n| Set-AlternatingRows -CSSEvenClass even -CSSOddClass odd\n\n\n$output | out-file $OutputPath\nif($Interactive) { invoke-expression $OutputPath }\n\u00a0\n\n<\/pre>\n<p>Copy the script above into a text editor and save it as a .ps1 file. From there you can execute it via the command line or run it as a schedule task. For example:<\/p>\n<p>.\\CheckDesktopsAvailable.ps1 -SitesToMonitor &#8220;site1.contoso.local&#8221;,&#8221;site2.contoso.local&#8221; -OutputPath &#8220;C:\\temp\\report.html&#8221; -Interactive<\/p>\n<p>If you are running the script as a scheduled task, omit the -Interactive switch to receive the file only. You can then integrate the output via another method into your monitoring platform of choice.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When you manage multiple sites you may find that Citrix Director lacks an \u201cat-a-glance\u201d view of the status of multiple sites. This becomes extra apparent in a large pod-based design where multiple sites may exist within the same datacenter or in an active-active datacenter setup. With VDI, it is important to check the total number [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[10,77],"tags":[100,103,119,122],"_links":{"self":[{"href":"https:\/\/avtempwp.azurewebsites.net\/wp-json\/wp\/v2\/posts\/4491"}],"collection":[{"href":"https:\/\/avtempwp.azurewebsites.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/avtempwp.azurewebsites.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/avtempwp.azurewebsites.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/avtempwp.azurewebsites.net\/wp-json\/wp\/v2\/comments?post=4491"}],"version-history":[{"count":0,"href":"https:\/\/avtempwp.azurewebsites.net\/wp-json\/wp\/v2\/posts\/4491\/revisions"}],"wp:attachment":[{"href":"https:\/\/avtempwp.azurewebsites.net\/wp-json\/wp\/v2\/media?parent=4491"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/avtempwp.azurewebsites.net\/wp-json\/wp\/v2\/categories?post=4491"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/avtempwp.azurewebsites.net\/wp-json\/wp\/v2\/tags?post=4491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}