Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    Monitoring Gateway with Reports

    Scheduled Pinned Locked Moved General pfSense Questions
    7 Posts 3 Posters 1.3k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • F
      floydque
      last edited by

      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

      1 Reply Last reply Reply Quote 0
      • dennypageD
        dennypage
        last edited by

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

        1 Reply Last reply Reply Quote 0
        • F
          floydque
          last edited by

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

          Thanks

          1 Reply Last reply Reply Quote 0
          • DerelictD
            Derelict LAYER 8 Netgate
            last edited by

            Print to PDF in your browser?

            Chattanooga, Tennessee, USA
            A comprehensive network diagram is worth 10,000 words and 15 conference calls.
            DO NOT set a source address/port in a port forward or firewall rule unless you KNOW you need it!
            Do Not Chat For Help! NO_WAN_EGRESS(TM)

            1 Reply Last reply Reply Quote 0
            • dennypageD
              dennypage
              last edited by

              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]

              1 Reply Last reply Reply Quote 0
              • F
                floydque
                last edited by

                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%

                1 Reply Last reply Reply Quote 0
                • dennypageD
                  dennypage
                  last edited by

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

                  1 Reply Last reply Reply Quote 0
                  • First post
                    Last post
                  Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.