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.
1 Reply
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
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.
Add comment