Export - edit - import

Hello,

Thank you for your message. Can you please describe what you would like to achieve exactly ?

To export a list of sensors, you can use the API of PRTG with the following API request :

https://PRTGSERVER/api/table.xml?content=sensors&output=xml&columns=objid,probe,group,device,sensor,status,message,lastvalue,priority,favorite&count=*&username=PRTGUSER&passhash=PASSHASH

However, I'm afraid that it's not possible to import modified sensors in PRTG. You can create new ones by duplicating existing sensors or applying specific device template. Or simply modify the sensors directly in PRTG via API calls, with the help of the PowerShell module PRTGAPI.

Kind regards.

With autodiscovery I have filled many groups. In each group are many discovered nodes. But the nodes are presented with their IP address and I want to add extra information. In Excel this is much easier done than in the PRTG webinterface.

So I hoped it would be possible with exporting them, adding info via Excel and then import them again.

Kind regards

Thank you for the information.

Can you please tell me which information you would like to modify/add to the devices/sensors ?

If you want to modify their settings, then I recommend to the the PowerShell module PRTGAPI. You can get the sensors settings by using the cmdlet Get-Sensor | Get-ObjectProperty.

Please, notice that it's not possible to import sensors in PRTG, however as you have their object id, you can execute API calls to modify them.

Have a look to the wiki of the module for more information: https://github.com/lordmilko/PrtgAPI/wiki

Kind regards.

After exporting to excel, I want to change the name of the devices. Now they are presented with the IP address as name. I want to filter in excel on all node address .218 and change the name to: <device type> - <device name> - IP address

And this for all node addresses, because we give devices an IP address, based on the type of device.

Hope this will clear it up :-)

Thank you, it makes it more clear indeed.

Therefore, I invite you to generate the list of devices with the following API call:

https://PRTGSERVER/api/table.xml?content=devices&output=xml&columns=objid,probe,group,device,host&count=*&username=PRTGUSER&passhash=PASSHASH

Then, after having modified the XML file, write a script to modify each device's name in PRTG based on their id. You can use the following API call to do the change:

https://PRTGSERVER/editsettings?id=DEVICE_ID&name_=NEW_NAME&username=PRTGUSER&passhash=PASSHASH

Regards.

thanks you very much for your time and advice :-)