I need to perform an audit of our PRTG installation to get an idea of what sensors we are running on our devices across our network. Is there any way of exporting a device and it's sensors into an excel supported format (such as CSV)? Even a plain text format might work if the devices are broken up in a uniform manner as I could use Excels columns to text feature.
Export device sensor list to Excel
Votes:
2
9 Replies
Votes:
1
Hi,
the only way to create such list would be the PRTG API. The documentation and also a query builder for API calls can be found at http(s):YOUR_PRTG_SERVER/api.htm. There please switch to tab Live Data. You should find everything needed there.
Best regards
Votes:
0
That's perfect, thanks very much. Exported as CSV and now I have a ready made list of sensors. Saves me doing this manually!!
Votes:
0
Hello,
Is there any way to export more than 500 lines? Well, I need to export a list with all my sensors, in all there are almost 2000 thousand.
Tks!
Votes:
0
Please add a
&count=XXXX
parameter to the URL. With this you can adjust the number of returned results. For example 1000 there will return 1000 results ;-).
Votes:
0
There is no sensor "Type" in Query Builder, how can i sort sensors by Type after export to CSV? For examle i want to export all exising sensors, but after sort only SNMP Traffic?
Votes:
0
Try using filtering by tag (filter_tags) and using the default tags (remember, each sensor type has a default tag).
Votes:
0
Hello All,
Sorry I am no coder by any means, would someone be able to explain how to extract the sensor list into excel for audit purposes based on tag name?
Thank you in advance,
Votes:
0
Hello there,
You can convert this quite easy with excel. Please follow these steps:
- Open the CSV file with Excel
- Mark the first column
- Click "Data" > "Text to Columns"
- Next
- Choose the needed Delimiters
Kind regards,
Birk Guttmann, Tech Support Team
Votes:
0
Maybe this will help someone :-)
Export (up to) 3000 sensors to CSV
Add comment