I downloaded the tool but can't use it

Article Comments

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":

  1. Please right-click the XML-link
  2. Choose "Save Link Address"
  3. Open a new browser tab and paste the copied URL - but please do not press enter afterwards, just paste the URL
  4. 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
  1. Once you have done this, please press enter-key and you will receiver a CSV-file of the current view.
  2. Please open the CSV-file in a text-editor (I suggest notepad++)
  3. Please enter a new line with the following string "sep=," (without " "). Please save the file afterwards
  4. At the end, you can open the CSV-File in MS Excel and et voilà .. a CSV-export.

Kind regards,
Sven


Dec, 2016 - Permalink

Thanks Sven

Actually I don't find the link "XML" in my viewer so if you could please share a snap shot from it.


Dec, 2016 - Permalink

Dear naderwahba,

please use the web GUI instead of the Enterprise Console.

Navigate to e.g. "Alarms", scroll down to the end of the page and you will find the link in the lower right corner.

Best regards


Dec, 2016 - Permalink