What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
300.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags


View all Tags

export to excel from PRTG alert list

Votes:

0

Your Vote:

Up

Down

Hi,

Need to find a solution to export to excel the PRTG listings of the warnings or alerts, so it will be much more efficient to work . Tried to find the needed option , but without any luck.

Thanks.

excel export list

Created on Nov 2, 2014 8:47:58 AM by  gonen (0) 1



4 Replies

Votes:

0

Your Vote:

Up

Down

Dear Gonen

This is currently only possible with an API call. An example call would be

/api/table.csv?id=0&content=sensors&columns=objid,status&count=*&filter_status=5

This call creates a CSV file which can be imported by Excel.

Please go to the PRTG menu Setup / PRTG API, tab "HTTP API" to see how to complete this example with your PRTG webserver address and user credentials.

The filter_status command causes that you only see sensors which are in a certain state. Valid status numbers are:

0 = None 1 = Unknown 2 = Collecting 3 = Up 4 = Warning 5 = Down 6 = NoProbe 7 = PausedUser 8 = PausedDependency 9 = PausedSchedule 10 = Unusual 11 = PausedLicense 12 = PausedUntil 13 = DownAck 14 = PartialDown

Created on Nov 3, 2014 3:29:23 PM by  Arne Seifert [Paessler Support]



Votes:

0

Your Vote:

Up

Down

I tested the URL posted above in various iterations of failure on any API call made, so I'm confident I'm missing something as a new user here :) I am consistently getting http response code 302 (redirect)... or in the docs here something like 'object created' it says but definitely no output to the screen that I can carry into Excel and work with.

curl -o prtg-alarms.csv -v -k "http://myprtgbox/api/table.csv?id=0&content=sensors&columns=objid,status&count&username=myname&passhash=123456789" % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0* Trying 10.22.33.233...

  • TCP_NODELAY set
  • Connected to myprtgbox(10.22.33.233) port 80 (#0) > GET /api/table.csv?id=0&content=sensors&columns=objid,status&count&username=efaile&passhash=179377612 HTTP/1.1 > Host: myprtgbox > User-Agent: curl/7.55.1 > Accept: */* > < HTTP/1.1 302 Moved Temporarily <------------ Regardless of minor tweaks to syntax - no data returns < Connection: close < Content-Type: text/html; charset=ISO-8859-1 < Content-Length: 0 < Date: Wed, 02 Dec 2020 00:15:37 GMT < Expires: 0 < Cache-Control: no-cache < X-Content-Type-Options: nosniff < X-XSS-Protection: 1; mode=block < Server: PRTG < Location: https://myprtgbox/api/table.csv?id=0&content=sensors&columns=objid,status&count&username=myname&passhash=123456789

I'm probably just rusty here, but could you offer input? Every sample api call I found in the kb I get this (or 401 Unauthorized if I don't double quote the whole string).

Created on Dec 2, 2020 12:24:48 AM by  Eva (0)



Votes:

1

Your Vote:

Up

Down

Hello,

is there any NAT or port forwarding between the computer and the PRTG server? This could yield that response.

If you run your PRTG server as HTTPS, please try use the respective port (probably 443) in the address.

Created on Dec 2, 2020 3:41:33 PM by  Arne Seifert [Paessler Support]



Votes:

0

Your Vote:

Up

Down

You were spot on target! The http(80)/https(443) distinction was the difference. As soon as I changed the URL to have https (vs. http which I just frankly overlooked) - the data was quickly and efficiently downloaded. For those who may encounter the same issue - here is precisely the working syntax:

curl -o prtg-alarms.csv -v -k "https://myprtgbox/api/table.csv?id=0&content=sensors&columns=objid,status&count&username=myname&passhash=123456789"

This downloaded some data and created the output file prtg-alarms.csv to the tune of a 13k file.

Much obliged for the rapid (and accurate) reply.

Created on Dec 2, 2020 10:16:14 PM by  Eva (0)



Please log in or register to enter your reply.


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.