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

    SQUID Individual User reports email

    Scheduled Pinned Locked Moved Off-Topic & Non-Support Discussion
    3 Posts 3 Posters 3.4k 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.
    • R
      ritterskampj
      last edited by

      I am looking for a solution which will allow individual user reports to be sent to a specific email address at a predefined time period.  Specifically, using PFSense/SQUID at a school, and automatically emailing student user reports on a weekly basis to parent's email address. If this is possible using PFSense, it will save the school thousands of $$.

      1 Reply Last reply Reply Quote 0
      • N
        Nachtfalke
        last edited by

        @ritterskampj:

        I am looking for a solution which will allow individual user reports to be sent to a specific email address at a predefined time period.  Specifically, using PFSense/SQUID at a school, and automatically emailing student user reports on a weekly basis to parent's email address. If this is possible using PFSense, it will save the school thousands of $$.

        I do not know any good and easy solution for emailing things but for doing reports on squid access log you can use the SARG package on pfsense. Another package is "Mail reports" but I do not know what it mails. But perhaps it gives you a point to start an change some code and email reports from SARG package. As far as I know SARG reports are HTML sites.

        1 Reply Last reply Reply Quote 0
        • jimpJ
          jimp Rebel Alliance Developer Netgate
          last edited by

          The mail reports package can run any custom command you want and the output is included in the e-mail inline as text, however it can only e-mail to one address (the one configured to receive notifications)

          That's not to say it someone couldn't use that code as a base to do what you're after. All the functionality is there to e-mail anywhere there's just not an option in the GUI to set that up. (to e-mail people, not to generate the user reports)

          If someone can come up with a way to make the reports per-user using a command line script, then the mail reports package could do what you're after with some modifications.

          Remember: Upvote with the 👍 button for any user/post you find to be helpful, informative, or deserving of recognition!

          Need help fast? Netgate Global Support!

          Do not Chat/PM for help!

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