I have one that I need to improve, if anyone wants to use if for inspiration. The first one basically gets all the sessions, and outputs them to an csv. the second one gets the max count average count and emails it out. I have the first one running every 15 minutes and the other 1 running once a month. That lets me get a general idea on the average number non persistent desktops I need and what kinda spikes we can expect. The only thing is you need the hv.helper module PowerCLI-Example-Scripts/Modules/VMware.Hv.Helper at master · vmware/PowerCLI-Example-Scripts · GitH... . I pulled out my specifics and put place holders, if anyone has any questions on what goes where let me know.
#Get Sessions script
===============================
Import-Module VMware.VimAutomation.HorizonView
Import-Module VMware.Hv.Helper
Connect-HVServer -Server <horizon server> -User <horizon user> -Password <horizon password> -Domain <horizon domain>
$sessions=(get-hvlocalsession).namesdata
$sessionsList=@()
$desktopPools=@()
$rdsFarms=@()
foreach($session in $sessions)
{
$desktopPools+=$session.DesktopName
$rdsFarms+=$session.FarmName
}
$desktopPools = $desktopPools | select -Unique
$rdsFarms= $rdsFarms | select -Unique
foreach($desktopPool in $desktopPools)
{
$count=0
foreach ($session in $sessions)
{
if($session.DesktopName -eq $desktopPool)
{
$count++
}
}
$obj = new-object PSObject
$obj | Add-Member -MemberType NoteProperty -Name "Time" -Value $(get-date).ToString()
$obj | add-member -membertype NoteProperty -name "Name" -value $desktopPool
$obj | add-member -membertype NoteProperty -name "Concurrent Users" -value $count
$sessionsList += $obj
}
foreach($rdsFarm in $rdsFarms)
{
$count=0
foreach ($session in $sessions)
{
if($session.FarmName -eq $rdsFarm)
{
$count++
}
}
$obj = new-object PSObject
$obj | Add-Member -MemberType NoteProperty -Name "Time" -Value $(get-date).ToString()
$obj | add-member -membertype NoteProperty -name "Name" -value $rdsFarm
$obj | add-member -membertype NoteProperty -name "Concurrent Users" -value $count
$sessionsList += $obj
}
$sessionsList | Export-csv -NoTypeInformation -Append C:\Scripts\conncurentuserreport\sessions.csv
#count sessions
==================================
$conncurrentUserCounts=Import-csv C:\Scripts\conncurentuserreport\sessions.csv
$vdiPools=@()
$connUserReport=@()
foreach ($userCount in $conncurrentUserCounts)
{
$vdiPools+=$userCount.Name
}
$vdiPools=$vdiPools | select -Unique
foreach($vdiPool in $vdiPools)
{
$max=0;
$avg=0;
$count=0
$sum=0
foreach($userCount in $conncurrentUserCounts)
{
if($userCount.Name -eq $vdiPool)
{
$num=[int]$userCount.'Concurrent Users'
if($num -gt $max)
{
$max=$num
}
$sum+=$num
$count++
}
}
$avg=$sum/$count
$obj = new-object PSObject
$obj | Add-Member -MemberType NoteProperty -Name "Name" -Value $vdiPool
$obj | Add-Member -MemberType NoteProperty -Name "Average Concurrent Users" -Value $avg
$obj | Add-Member -MemberType NoteProperty -Name "Max Concurrent Users" -Value $max
$connUserReport+=$obj
}
$connUserReport | Export-csv -NoTypeInformation C:\Scripts\conncurentuserreport\connCurrentUserReport.csv
Send-MailMessage -Attachments "C:\Scripts\conncurentuserreport\sessions.csv","C:\Scripts\conncurentuserreport\connCurrentUserReport.csv" -SmtpServer $smtpserver -From $fromaddress -Subject "Concurrent User Report" -to $toaddress
Remove-Item C:\Scripts\conncurentuserreport\sessions.csv
Remove-Item C:\Scripts\conncurentuserreport\connCurrentUserReport.csv
