I need a report of all my devices in prtg probe,

Article Comments

Hi there,

In order to retrieve the CSV file, simply connect to your PRTG webinterface via a webbrowser, login and change the URL accordingly:

http(s)://<SERVER>/api/table.csv?content=devices&columns=objid,probe,group,device,host&count=*

Afterwards you can open this Comma Separated Values file in Excel. To divide the data into multiple rows, just navigate to "Data > Text to Columns > Delimited > Comma".

Bes regards.


Dec, 2017 - Permalink

Hi

http://192.168.1.9/api/table.csv?content=devices&columns=objid,probe,group,device,host&count=*&columns=sensor&username=login&password=password

I receive this back

"??????","??????(RAW)"
"",""
"",""
"",""
"",""
"",""
"",""

What to do?


Feb, 2018 - Permalink

Hi there,

You added "columns" twice in the call. Please use the following URL instead and check again:

http://192.168.1.9/api/table.csv?content=devices&columns=objid,probe,group,device,host&count=*&username=login&password=password

Does it work now?

If not, please use the following URL to check if you get anything as JSON:

http://192.168.1.9/api/table.json?content=devices&columns=objid,probe,group,device,host&count=*&username=login&password=password


Best regards.


Feb, 2018 - Permalink