Guest User!

You are not Sophos Staff.

Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 6 replies
  • Subscribers 2 subscribers
  • Views 11175 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

DHCP lease report?

Jens JakobSorensen
In order to document the number of users on our network, I would like to have a report on the number of DHCP leases provided on a daily or monthly basis.
The data is listed in the “DHCP Server Log”, but no reporting tool to extract the information from it.

Is it possible to include this info in the “Executive Report”?
Or to extract it from the log files otherwise?


Jens Jakob, Dansk Centralbibliotek for Sydslesvig
UTM 9.112-12


This thread was automatically locked due to age.
Parents
  • 0
    To show and count the IPs used in the last seven days, run, at the command line: /usr/local/bin/count_active_ip.plx --showcount

    In 'Logging & Reporting >> Network Usage', on the Bandwidth Usage tab, select a report on "Top Clients" for "Last 7 days" or other time frame.  Click on the spreadsheet icon to download as CSV. (Beforehand, go to the bottom of 'Report Settings' and set CSV to comma instead of semi-colon if needed.)

    Cheers - Bob
     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
Reply
  • 0
    To show and count the IPs used in the last seven days, run, at the command line: /usr/local/bin/count_active_ip.plx --showcount

    In 'Logging & Reporting >> Network Usage', on the Bandwidth Usage tab, select a report on "Top Clients" for "Last 7 days" or other time frame.  Click on the spreadsheet icon to download as CSV. (Beforehand, go to the bottom of 'Report Settings' and set CSV to comma instead of semi-colon if needed.)

    Cheers - Bob
     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
Children
  • 0 in reply to BAlfson
    Perhaps a really stupid question: Is there a way to access CLI from the web-interface? Or can I use putty?

    The CSV-file from Network Usage do provide a list of all used IP in a way, where they are easy to count. But unless the CLI script changes something, I can't see for how many leases an IP-address has been used.

    I might have to wait for the feature to be implemented by Sophos.

    / Jens Jakob
Share Feedback
×

Submitted a Tech Support Case lately from the Support Portal?