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.

Article Comments

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.


Oct, 2021 - Permalink