What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general.

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags


View all Tags

How do i export the alarms as xls or csv?

Votes:

0

I downloaded the tool but can't use it

prtg snmp wmi

Created on Dec 20, 2016 1:32:43 PM



3 Replies

Accepted Answer

Votes:

0

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

Created on Dec 21, 2016 2:56:49 PM by  Sven Roggenhofer [Paessler Technical Support]

Last change on May 27, 2022 7:55:28 AM by  Felix Saure [Paessler Support]



Votes:

0

Thanks Sven

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

Created on Dec 22, 2016 10:33:24 AM



Votes:

0

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

Created on Dec 22, 2016 1:22:16 PM by  Sven Roggenhofer [Paessler Technical Support]




Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.