Long story short, we have a 40 odd domains (related to DDoS) that we need to pull off a report for who's being visiting them over the last 30 days.
Now, I can't use the log viewer, because as Sophos have advised that only has a couple or so days worth of data to keep it "fast". So I raised a case and was advised to ssh and comb the logs there. I couldn't find the data, had Sophos on the phone and neither could they.
We then had a look at reports, but to pull off a report for one domain for 60 days took 2+ minutes, then I had to export each 200 record page, one by one as the export tool doesn't export the whole thing. And then repeat the process for the remaining 39 domains, as the report we created could only take a single domain at a time.
I feel like I'm missing something obvious.
For the sake of brevity, what's the quickest way you would pull off a 60 day report for bbc.co.uk and channel4.com showing which uses hit them the most?
This thread was automatically locked due to age.
