Dear naderwahba,
Thank you very much for your KB-post.
When you navigate to the alarms/logs/sensor list, you will find a little link "XML" in the lower right corner of the list. If you click on that link, the system will automatically download the current view as XML-file.
If you want to have this as CSV-file for Excel as well, you have to do a little "trick":
- Please right-click the XML-link
- Choose "Save Link Address"
- Open a new browser tab and paste the copied URL - but please do not press enter afterwards, just paste the URL
- Please edit the pasted URL as follows:
from <Your Core Server>/api/table.xml?content=messages......
to <Your Core Server>/api/table.csv?content=messages......
Remember that it will require authentication for each API call, with &username=XXX&password/passhas=YYY
The complete call could also look like this:
https://<YourCoreServer>/api/table.csv?id=0&content=sensors&columns=objid,message,status&count=*&filter_status=5&username=prtgadmin&password=prtgadmin
- Once you have done this, please press enter-key and you will receiver a CSV-file of the current view.
- Please open the CSV-file in a text-editor (I suggest notepad++)
- Please enter a new line with the following string "sep=," (without " "). Please save the file afterwards
- At the end, you can open the CSV-File in MS Excel and et voilà .. a CSV-export.
Kind regards,
Sven
Add comment