I am looking for a way to count sensors per probe for billing purpose. It would be nice to automatically generate this rapport on a monthly base. I can't find a way to do that. Is it possible en if yes, how?

Only one row per probe with amount of sensors should be enough (for know :-) )

Article Comments

Hello,

it should be possible to get this information from the API, please see "Setup"->"PRTG API"->"Live Data" and the "XML Table Query Builder" for details.

best regards.


May, 2012 - Permalink

Torsten,

Any hints on the query that is built to accomplish this request? We've made numerous attempts to get an output from the database with just the number of sensors associated with each probe, but have not been successful. We've ended up getting a line by line listing of all sensors (with a count of 1 per sensor at the end), but not a simple report such as the desired:

PROBE 1  (120)
PROBE 2  (125)
PROBE 3  (45)
PROBE 4  (1000)

Any help would be greatly appreciated.

Todd


May, 2018 - Permalink

Hi Todd,

thank you for the post. I'm afraid the best I can do would be a list of groups (with Probe names attached):

/api/table.xml?content=groups&output=csvtable&columns=objid,probe,group,totalsens&id=1

Here I'm filtering for only the Local Probe (id=1 at the end of the URL), you could also leave that to get it from all Probes. A list of just Probes isn't possible I'm afraid, the API does not have an according call. Getting the sensor count per Probe will require some type of calculating this externally (in a script or similar). Sorry.


May, 2018 - Permalink