Monitoring Gateway with Reports



  • Is there a way to monitor the gateway connection to my ISP and then I'll just generate daily reports?
    I need this to troubleshoot my connection and send to my ISP.

    Thanks



  • Would it be sufficient to generate graphs and print them? Alternatively, you can export the data as a CSV and provide it to them.



  • This is what I am looking for. However, I cannot find the export function.

    Thanks


  • Netgate

    Print to PDF in your browser?



  • Go to Status / Monitoring. Select the wrench in the upper right. Set the time period and resolution you desire, and then select "Export As CSV"

    Note that this will come as a pop-up, so you have to have pop-up windows allowed in the browser.

    [jdillard, it would be awesome if these were not a pop-up]



  • Got it. Thanks!

    Can you help me do a CSV reporting that it lists latency loss.

    Example:
    Oct 13 16:29:57 dpinger WAN_DHCP 222...*: Alarm latency 82880us stddev 46313us loss 21%



  • @floydque:

    Can you help me do a CSV reporting that it lists latency loss.

    Example:
    Oct 13 16:29:57 dpinger WAN_DHCP 222...*: Alarm latency 82880us stddev 46313us loss 21%

    That's what you are getting in the CSV. The header you will see is:

    ,packet loss,delay average,delay std. dev.,
    

    The first field (with the missing header description) is is a timestamp. The timestamp is a standard Unix timestamp with 3 digits of milliseconds appended. You will have to convert this field to the date/time format you want. The packet field is in percent, and the delay fields are in milliseconds.

    The timestamp is pretty easy to convert in Python or Perl. However, if your target is a spreadsheet, you can convert the timestamp with a formula:

    =((A1/1000)/86400)+25569
    

    Hope this helps.