So with the recent event's with covid-19, my company is having more and more employees work from home using the client VPN connection, I am needing to generate a weekly report on who connects, when they connect and disconnect, and it would also be nice to see how long they were connected overall each day. I know I can go and check the logs to see the VPN activity but doing this manually is pretty tedious. I want to know if it is possible to create a script or if there are some that are already created that will do what I am looking for or if there is a piece of software that will parse the logs and generate a report for me, any input is greatly appreciated!
I would not depend on the Meraki Dashboard for this information, i would instead look to setup a syslog server that you could more easily interrogate on an automated basis. It will very likely be easier to interrogate, and potentially a lot of syslog interrogators out there have the query ready for you.