WMI CUSTOM STRING: need help with output

Be aware of the following:

• PRTG only evaluates numeric numbers
• WQL (WMI Query Language) does not have a COUNT(*) option

With that in mind, you'll need to use PowerShell to evaluate the output of the WMI query and put it in the following format: <value>:<message>

The sensor will always go down if there are no actual values to return, which is not the case with a PowerShell sensor. It will simply stay at 0, when the variable is initialized with the same: $value = 0;

Kind regards,
Stephan Linke, Tech Support Team

Thanks Stephan,

So, just that I understand, if I use Powershell to query WMI, I would need to re-write it in PowerShell? Then presumably change my sensor so that it uses (and points to) the new PowerShell script?

Sorry for the noob questions. This is my first time dabbling with WMI/WQL and custom scripts.

Thanks in advance.

Thank you. After re-reading your answer are you suggesting I use two solutions; WQL for the message and powershell to count the number of users logged in?

Or can both be achieved with a single Powershell script?

If so, can you elaborate on how I can evaluate the WMI query results with Powershell? I'm not sure where to put <value>:<message>

Thanks.

Ok, after some more trial and error, I now have the following, which gives me a sensor count of the number of logged in users...

$RDSGatewayServer = "gatewayserver.domain.com" $Namespace = "root\cimv2\TerminalServices" $GatewayLoggedInUsers = @(get-wmiobject -class Win32_TSGatewayConnection -computername $RDSGatewayServer -namespace $Namespace).Count Write-Host "<prtg>" "<result>" "<channel>Users Logged into RDS Gateway</channel>" "<value>"+$GatewayLoggedInUsers+"</value>" "</result>" "</prtg>"

Now, is it possible to add the FullUserName output from the WQL script to this, so I can identify who the users are?

$Users = (Get-WmiObject -Query "<wql query>" -ComputerName <targethost>)

:)

Um, ok, thanks. I'm not sure what to do with the code in your reply, so I have guessed where it should go and how to deal with the output.

$RDSGatewayServer = "gatewayserver.domain.com" $Namespace = "root\cimv2\TerminalServices" $GatewayLoggedInUsers = @(get-wmiobject -class Win32_TSGatewayConnection -computername $RDSGatewayServer -namespace $Namespace).Count $Users = (Get-WmiObject -Query "C:\Program Files (x86)\PRTG Network Monitor\Custom Sensors\WMI WQL scripts\RDSGatewayMonitoring.wql" -ComputerName $RDSGatewayServer) Write-Host "<prtg>" "<result>" "<channel>Users Logged into RDS Gateway</channel>" "<value>"+$GatewayLoggedInUsers+"</value>" "</result>" "<result>" "<channel>Users</channel>" "<value>"+$Users+"</value>" "</result>" "</prtg>"

I'm getting the following error

Get-WmiObject : Invalid query "C:\Program Files (x86)\PRTG Network Monitor\Custom Sensors\WMI WQL scripts\RDSGatewayMonitoring.wql" At C:\Program Files (x86)\PRTG Network Monitor\Custom Sensors\EXEXML\RDSGatewayLoggedOnUsers.ps1:4 char:11 + $Users = (Get-WmiObject -Query "C:\Program Files (x86)\PRTG Network M ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidArgument: (:) [Get-WmiObject], ManagementException + FullyQualifiedErrorId : GetWMIManagementException,Microsoft.PowerShell.Commands.GetWmiObjectCo mmand

I have double-checked the path to WQL is correct.

You'll need to use the actual query, not the path to the query file :)

Kind regards,
Stephan Linke, Tech Support Team