Statistics (logging) of visited sites by users, how to do it?

Question

Mikrotik

There is a grid, they go through Mikrotik, how to organize statistics of visited sites by users? I tried Webproxy-log - it does not work, because it does not see https sites. How to organize logging of all sites or is it not possible?

Answer 1

Oh my God, this question is gradually becoming a leader - we did meet Comrade Yn for a reason recently ...
A proxy is used to log access. To expose https, squid is used with bumping (and statistics). For bumping to work, you need to have your own CA (there is a server in Windows), distributed to all computers on the network as trusted ones. There is no other way to crash into https (and this one does not work everywhere).

Answer 2

Raise squid in transparent mode and analyze its logs, for example lightsquid.