Greetings,

I´m interested in creating a historicdata query to the prtg API that can also have a column with the object ID into the csv.

Right now I got this which is the normal API call:

http://<prtgserver>/api/historicdata.csv?id=100015&avg=3600&sdate=2018-08-15-00-00-00&edate=2018-08-16-00-00-00&username=<user>&passhash=<hash>

the normal output file would have columns like this:

Date Time, Date Time(RAW), Value, Value(RAW), Downtime, Downtime(RAW),	 Coverage, Coverage(RAW)

The desired result would be something like this:

ID, Date Time, Date Time(RAW), Value, Value(RAW), Downtime, Downtime(RAW), Coverage, Coverage(RAW)

Where Id is the object Id of the sensor and would be repeated on each row.

Is it possible?

As always thanks for your time and help!

Article Comments

Hello Anderson,

First I thought it should be possible by adjusting "historicdata.csv" located in PRTG's installation path, subfolder webroot\api but so far I've found no way no matter which parameter I've tried to add to the "columns" section.

Kind regards,

Erhard


Aug, 2018 - Permalink

Is it possible then, to create a table.csv call, that can include sensor information and historic data? I made one but it only brings a total value per day for uptime, downtime and coverage, would be possible to bring all day hours using the condition avg=3600 in table.csv?


Aug, 2018 - Permalink

Hi Anderson,

I'm afraid that is not possible, only what's described in PRTG in "Setup | PRTG API | Historic Data".

Kind regards,

Erhard


Aug, 2018 - Permalink