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

Attention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.

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