export to excel from PRTG alert list

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

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).

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.

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.