OpenVPN connected-disconnected users log

  • Hi everyone:

    We  have a roadwarrior openvpn service in our company. I need to report how long time the users are connected to the vpn. The hour of users connected and the hour the users disconnected. I have a rsyslog in other server, so I can read the openvpn log daily, and I cleaned the "trash info" with an excel macro and extract the info that I need, but how can I get a report of the connect-disconnect hours of the users in automatic mode like this?

    User        Connect    Disconnect
    ALONSO  08:00        10:45
    ALONSO  12:33        18:42
    MARIA      20:11        23:09

    Do you have any idea?

    I hope you can help me.


Log in to reply