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

Exclude Networks from Reporting - How?

Hi Guys,

I have a quite big CCTV network connected to my UTM, everything works as it should.

 

The only problem I have is that the, otherwise useful, Executive Report, is now a bit overloaded by this as all TOP clients are cameras in Application Categories RTP Streaming is everyday around 95% of the traffic.

in Reporting Settings-> Expections I can define IPs to exlude from reporting....but not network definitions or complete networks as it seems...is there a way that could save me typing in more than 100 IPs manually? Defining the whole network by CIDR doesn´t work.

 

Thanks in advance

M.



This thread was automatically locked due to age.
  • Hi, Matthias, and welcome to the UTM Community!

    To paste in a list that you can create with a spreadsheet or other tool, click on the selection to the right of the green +.

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  • Hi Bob,

     

    didn´t really get that, just pasting an IP-list out of Excel for example didn´t work, I can paste them and press apply, but when I refresh the page the settings isn´t saved.

     

    Which format did you insert? Comma separated?

    Regards,

    Matthias

  • One IP per line, no commas, semi-colons or anything other than pure, numeric IPs.  Cut and paste directly from Excel.

    Cheers - Bob

    PS Chuckling - luckily I caught myself when I was tempted to say RTFM! [;)]  In fact, I just tried unsuccessfully to find any hint at all.

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  • Good to know, so now I can claim to have read the manual before posting and you wouldn´t be able to prove the opposite ;-)

     

    Maybe it´s me, but no matter if I copy them from Excel, Notepad or something else, I always end up with this:

    Funny thing is: That´s how it looks like when using Firefox. When using IE to paste, I end up with only the first IP pasted.

    So if it works on your side....which browser do you use? :-)

  • One. IP. per. line.  [:D]

    Firefox 49 & IE 11.

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  • OK, maybe we´re not talking about the same thing here.

    What I do have is an Excel sheet looking like this, One. IP .per.line :-) :

    Then I copy that and paste it by Firefox to the Sophos, ending up with the mess you see in the picture above. So that doesn´t work for me.

    Of course I can copy them one-by-one to the sophos, clicking the green plus 253 times in between, I opened this thread to avoid exactly this...

  • What happens if you copy it first into notepad and them copy from there to WebAdmin?  Still, I don't understand why it did that to you.

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  • Already tried that with Notepad++ and the Windows notepad, result is the same.

     

    The only thing that changes something is the browser. Firefox + Edge are putting all IPs in one line, Internet Explorer only pastes the first line....

  • You can paste one line at a time into the import box if you can't find a way to get Excel to play nicely.

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA