topic Re: How can I export all tunnel VPN users to CSV? in API / CLI Discussion

How can I export all tunnel VPN users to CSV?

SHussain — Tue, 02 May 2023 18:36:59 GMT

Hello,

Is it possible to export all users that are currently connected through VPN? I am able to view this information in the GUI of SmartConsole but there is no easy way to export this information. I am looking to include the username and IP of each user when exporting. Pardon my experience as I am a beginner... any help or guidance in the right direction is greatly appreciated!

Re: How can I export all tunnel VPN users to CSV?

PhoneBoy — Tue, 02 May 2023 21:51:57 GMT

From the relevant gateway, you can execute the command:

fw tab -t userc_users -f -u

It will require a small amount of scripting to get it into the desired format.
One example: https://community.checkpoint.com/t5/Scripts/Show-VPN-Users-One-liner/m-p/134011#M890