Create a Post
cancel
Showing results for 
Search instead for 
Did you mean: 
rogerhuang
Explorer

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

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

0 Kudos
3 Replies
rogerhuang
Explorer

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?

0 Kudos
the_rock
Authority
Authority

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

0 Kudos
PhoneBoy
Admin
Admin

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

0 Kudos