Average Sensor Uptime

Hi @Arne,

Following up on the three step process provided above, I had a couple questions in regards to generating the list and the Powershell aspect.

If I wanted to output the list of sensors the same as the uptime of the sensors. Would the following work?

$apiurl="http://prtg.server.com:8080/api/table.xml?id=0&content=sensors&columns=objid,name&count=*"
[xml]$result = (new-object System.Net.WebClient).downloadstring($apiurl)
$objectid ="objid"
write-host $result.sensors.item.$objectid.innertext

Because from that output I could input a variable for the sensors id and input in it:

$apiurl="http://prtg.server.com:8080/api/getsensordetails.xml?id="+$sensorid"
[xml]$result = (new-object System.Net.WebClient).downloadstring($apiurl)
$node="uptime"
write-host $result.sensordata.$node.innertext

Where $sensorid is = to $objectid.

Haven't worked out the logic 100%, but was wondering it the initial code block was something valid I could do? - also if the "write-host $result.sensors.item.$objectid.innertext" is correct

Dear Evan

I am sorry, our technical support does not cover the debugging of custom scripts. But I can tell you that the first example should use a foreach loop to iterate over all objid values.

foreach ($ID in $result.sensors.item.objid) 
{
    [... your code here, using $ID to access each ID with each loop ...]
}

Hi @Arne,

Sorry I don't think I was clear on what I was asking - I understand that you don't help with custom scripts, but thanks for trying to give me a bit of a pointer!

My question was more along the lines of the proper XML formatting for the output from:

/api/table.xml?id=0&content=sensors&columns=objid,name&count=*

Because the following doesn't work, despite the nodes in the XML table being:

$result.sensors.item.objid.innertext

<?xml version="1.0" encoding="UTF-8"?>
  <sensors totalcount="96" listend="1">
   <prtg-version>16.4.28.7352</prtg-version>
   <item>
    <objid>1001</objid>
    <name>System Health</name>
   </item>

I tend to try and give as much information as possible so you have an idea of why I am asking the question, but I may have added too much before and made it confusing for what I was asking for. Thanks for the help!

Dear Evan

The innertext method example only works if there is just one such node. Since the table returns many rows, please use a foreach loop to iterate over each according node.