Query for Inactive VPN users

[qwertyq691]

Ive had a quick search but cant seem to find an aswer to this one...

We have approximately 1000+vpn users.

We would like to query our log files and extract peoples last login times, and those who haven't logged on for the past 6months - in order to remove there accounts.

Currently i can do this by hand exporting each log file (1 per day) based on a query in smart tracker, into excel stripping out the duplicate users.

This only shows active users, and im still trying to export a list of our vpn users

This is tedious to say the least, and i cant go back to many days without developing repetitive strain injury! As i say i need to go back months :/

Does anyone know a script or any command line entries i could script myself to obtain this information?

Thanks
Steve

Additional Info
NGX R62 on SPLAT

[dsb.nepo]

Where are all these users defined?

If they are all definded at the firewall self (no ldap/radius ...) you can export them at the SmartCenter with the following command.

export users:
fwm dbexport -f ./fw_users.txt

export groups:
fwm dbexport -f ./fw_groups.txt -g

If you use external auth like radius ... look at the logs there.

Here is a good link to export the logs
fwm logexport cron with an perl/awk script it should be possible to extract the users.