Hi How do I do if I want to run a PowerShell command on remote server and display the count result in a graph, the command I want to run is this and just display the count as the result. "$(Get-RDUserSession -connectionbroker "FQDN.local").count"
Total user count RDS Windows 2016
Votes:
0
Best Answer
24 Replies
Votes:
0
Hello,
Thank you for the KB-Post. You can run Powershell Scripts with the Custom Exe/Script Advanced Sensor in PRTG. You need to make sure that the Powershell script contains code to connect to a target machine, because PRTG can only run the script on a Probe host machine.
Please bear in mind, as with all things customising, which includes script sensors, customizing on pages in PRTG (reports, map objects, etc.), users are on their own. This has to be done by the user. While we do have a few explanations and rough guides in our KB for that, as well as the API-Documentation, be aware, that it's only supposed to work as a base, and using it is at your own risk.
Please see our Guide For PowerShell Based Custom Sensors to start the project.
best regards.
Created on Jan 9, 2019 1:00:16 PM by
Votes:
4
We are using a Powershell Script in Combination with qwinsta to monitor our whole Farm - so just 1 Sensor for all RDSH Servers. Something like this:
$Servers = Get-ADComputer -Filter {Name -like "rdsh*"}
$SumTotal = 0
$SumActive = 0
$PRTGstring="<prtg>`r`n"
#Für jeden Server werden nun die Sessions abgefragt und in den PRTGString gespeichert
ForEach ($Server in $Servers) {
$ServerName = $Server.Name
$SessionsTotal = (qwinsta /server:$ServerName | ForEach-Object {$_.Trim() -replace "\s+",","} | ConvertFrom-Csv).Count-3
$SessionsActive = ((qwinsta /server:$ServerName | ForEach-Object {$_.Trim() -replace "\s+",","} | ConvertFrom-Csv) | ? { $_.$qwinstaState -eq $qwinstaActive }).Count
#Da -3 oben gerechnet wird kann es sein das Total negativ ist. Ist das der Fall wird es auf 0 gesetzt
if ($SessionsTotal -le 0){
$SessionsTotal = 0
}
#Jetzt wird der PRTGString mit Channels und Werten zusammengesetzt
$PRTGstring+=" <result>`r`n"
$PRTGstring+=" <channel>"+$ServerName+" Total"+"</channel>`r`n"
$PRTGstring+=" <value>"+$SessionsTotal+"</value>`r`n"
$PRTGstring+=" </result>`r`n"
$PRTGstring+=" <result>`r`n"
$PRTGstring+=" <channel>"+$ServerName+" Active"+"</channel>`r`n"
$PRTGstring+=" <value>"+$SessionsActive+"</value>`r`n"
$PRTGstring+=" </result>`r`n"
#Um am Ende auch die Summer aller Server zu erhalten
$SumTotal += $SessionsTotal
$SumActive += $SessionsActive
}
#Summe aller Server am Ende noch zusammensetzen
$PRTGstring+=" <result>`r`n"
$PRTGstring+=" <channel>"+"Summe Total"+"</channel>`r`n"
$PRTGstring+=" <value>"+$SumTotal+"</value>`r`n"
$PRTGstring+=" </result>`r`n"
$PRTGstring+=" <result>`r`n"
$PRTGstring+=" <channel>"+"Summe Active"+"</channel>`r`n"
$PRTGstring+=" <value>"+$SumActive+"</value>`r`n"
$PRTGstring+=" </result>`r`n"
$PRTGstring+="</prtg>"
#Ausgabe
write-host $PRTGstring
Last change on Jan 10, 2019 6:20:10 AM by
Votes:
0
Unfortunately not but like i sad it works when I execute the ps1 file from the prtg server in PowerShell. If I look at the “exe result” in the prtg folder it look like this
No session exists for *
No session exists for *
No session exists for *
No session exists for *
No session exists for *
<prtg>
<result>
<channel>xxxxRDSH000 Total</channel>
<value>0</value>
</result>
<result>
<channel>xxxxRDSH000 Active</channel>
<value>0</value>
</result>
<result>
<channel>xxxxRDSH001 Total</channel>
<value>0</value>
</result>
<result>
<channel>xxxxRDSH001 Active</channel>
<value>0</value>
</result>
<result>
<channel>xxxxRDSH002 Total</channel>
And when I look in PowerShell
PS H:\> C:\Program Files (x86)\PRTG Network Monitor\Custom Sensors\EXEXML\RDS_Active_Users_Monitor.ps1
<prtg>
<result>
<channel>xxxxRDSH000 Total</channel>
<value>28</value>
</result>
<result>
<channel>xxxxRDSH000 Active</channel>
<value>31</value>
</result>
<result>
<channel>xxxxRDSH001 Total</channel>
<value>27</value>
</result>
<result>
<channel>xxxxRDSH001 Active</channel>
<value>30</value>
</result>
<result>
<channel>xxxxRDSH002 Total</channel>
Last change on Jan 14, 2019 11:53:05 AM by
Votes:
0
Hi Florian Total amount of sessions in one sensor and total of found and the total of checked servers is good enough. I only want do display the information to the support and have the ability to see trend curves over time. I use $Servers = Get-Content "C:\Temp\servers.txt" as input
Last change on Jan 14, 2019 3:42:40 PM by
Votes:
0
Hi Florian,
first of all: Thank you so much for this script. This is exactly what I was looking for!
I have one problem:
In the first step I've tested the script with one RDS-server by using $ServerNames but the results are not as expected: It sais that there are no "Total Sessions active" but this is not correct. There was at least one active session. I have checked with the cmd.
Do you have any idea what could be the reason for this?
Many thanks!
<prtg>
<result>
<channel>Total Servers checked</channel>
<value>1</value>
</result>
<result>
<channel>Total Servers responded</channel>
<value>1</value>
</result>
<result>
<channel>Total Servers not reached</channel>
<value>0</value>
</result>
<result>
<channel>Total Sessions found</channel>
<value>18</value>
</result>
<result>
<channel>Total Sessions active</channel>
<value>0</value>
</result>
</prtg>
Last change on Jun 18, 2019 4:16:46 AM by
Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.
Add comment