What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
300.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags


View all Tags

API device export

Votes:

0

Your Vote:

Up

Down

Trying to find a way to export all devices by name with all sensors for each device in a CSV. So we can audit some 1200 devices and over 20k sensors to make sure each device as the appropriate ones.

api devices export sensors

Created on Oct 21, 2021 12:57:08 PM by  cpuppos (0) 1



1 Reply

Votes:

0

Your Vote:

Up

Down

Hello,

Thank you for your message.

To export a list of the devices with all their sensors I invite you to use the following API call:

https://PRTGServer/api/table.xml?content=sensors&output=csvtable&columns=objid,name,probe,group,favorite,lastvalue,device,downtime,downtimetime,downtimesince,uptime,uptimetime,uptimesince,knowntime,cumsince,lastcheck,lastup,lastdown,minigraph,schedule,basetype,baselink,notifiesx,intervalx,access,dependency,position,status,comments,priority,message,parentid,tags,type,active&count=*&username=PRTGUSER&passhash=PASSHASH

Please note that you have a consequent number of sensors and therefore executing the request will most likely have an impact on the Core server. To reduce the impact, I invite you to remove all the information you do not need by removing the corresponding columns (after "columns="). You can also hide raw values by adding "&noraw=1" in the request.

Finally, when the file is generated simply rename it to.csv so it can be opened with Excel.

If you have questions, do not hesitate.

Regards.

Created on Oct 22, 2021 7:02:30 AM by  Florian Lesage [Paessler Support]



Please log in or register to enter your reply.


Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.