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

[rogerhuang]

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

[rogerhuang]

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?

[the_rock]

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

[PhoneBoy]

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-u...