andy2017

Sophos UTM 220 or above, check on ebay, you can pick one up real cheap if you're lucky.

Thanks for that Wave9_Lee. Example to use Sophos XG 135 with our own hardware we still had to pay around £1700 to use their appliance, and for the bigger schools the price just went higher and higher. While Sophos is making the big money a lot of school are struggling with money to pay for these equipments and services, so I look for alternatives.

We are using Sophos enterprise for the antivirus and web control (I got an excellent deal for sophos enterprise for 3 years), Netsupport DNA is used for the safeguarding and has other useful features like print monitoring, and finally we have pfsense for the firewall. Regarding Sophos UTM and Sophos XG I have setup and used both of them and they are very good and user friendly, however, initial costs can be very expensive so the setup we have it worked out cheap and does the job.

80 device about 250 users

Here's a nice guide https://www.youtube.com/watch?v=W2gy1bLHm5o Also looks into e2guardian

Yes SSL is important or I wouldn't get the info i need. The certificates has been installed in my test lab, i was hoping for something easier like Sophos UTM/XG search engine logs. I guess python script maybe the only option for now. Is this essential (the google search logs) for the new PREVENT law? If it's not I could probably not spend so much time dwelling into it.

Physical machine, actually the hardware is Sophos UTM 320 and I just installed pfSense instead of using Sophos. I went through pfSense forum and some youtube videos. i did configure pfSense many years ago but I just couldn't remember all the options.

Look at some commercial auction websites, you'll find some good servers, hex cores, 10 cores, with multi physical processors with like 256 gig ram for around £700.

I've just configured pfSense with all the filters (squid guard, light squid) with user log activities and I just need to configure one other thing, which i'm struggling with, I need to find a way to log users search engine queries. Does anyone know how to accomplish this?