topic Re: How do I export all Endpoint security VPN users ID and Hostname into csv? in SASE and Remote Access

How do I export all Endpoint security VPN users ID and Hostname into csv?

rogerhuang — Sun, 12 Sep 2021 13:23:40 GMT

Using Smart Console or CPlgv.exe, how do I export "all" usersID, hostname and login date time into CSV?

Re: How do I export all Endpoint security VPN users ID and Hostname into csv?

rogerhuang — Sun, 12 Sep 2021 14:01:50 GMT

To be exact, the csv should contains All the end users ("User", "Time", "Office Mode IP", "Source Machine Name").
Can a Smart console do such export? Is it in the Query?

Re: How do I export all Endpoint security VPN users ID and Hostname into csv?

the_rock — Sun, 12 Sep 2021 14:03:54 GMT

I dont believe thats doable, but lets see what others say.

Re: How do I export all Endpoint security VPN users ID and Hostname into csv?

PhoneBoy — Sun, 12 Sep 2021 15:56:59 GMT

You can get a list of the users easily enough from the API.
There are newer ways to do this, but this should work in any R8x version: https://community.checkpoint.com/t5/API-CLI-Discussion/users-via-API/td-p/13578
The last login date and Office Mode IP would have to come from the logs since it’s not something we store with the user record.
One community-created report for this: https://community.checkpoint.com/t5/Remote-Access-VPN/Creating-Views-Log-in-and-log-out-events-and-user-analysis-VPN/m-p/120856#M5298