Hi How can I list all the devices and their sensors in Excel or export it from PRTG


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,

Thank you for the kbPost.

This is possible. To do this, use the following API-Call:

/api/table.csv?content=devices&columns=objid,probe,group,device,host&count=*

If you want just the devices of a certain group, then add the following parameter together with the ID of the group: &id=GROUP-ID

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".

Please let us know if you need anything else.


Mar, 2019 - Permalink