Can I export all my sensors to Excel, then edit them and import them again to overwrite the sensors?
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 :
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.
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.
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
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:
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:
thanks you very much for your time and advice :-)