cancel
Showing results for 
Search instead for 
Did you mean: 
Create a Post
Highlighted
Moe_89
Nickel

Remote VPN users report

Jump to solution

Hello,

Is there a way to export a list of Remote VPN users in the local MGMT database which includes last login time etc. ?

Something similar to fwm dbexport.

0 Kudos
1 Solution

Accepted Solutions
Admin
Admin

Re: Remote VPN users report

Jump to solution
You have to ask for the next 500 results like so:
mgmt_cli -r true --format json show generic-objects class-name com.checkpoint.objects.classes.dummy.CpmiUser limit 500 offset 500 | jq .objects []. Name
0 Kudos
6 Replies
Admin
Admin

Re: Remote VPN users report

Jump to solution

You can get a list of the users easily enough using the following command:

mgmt_cli -r true --format json show generic-objects class-name com.checkpoint.objects.classes.dummy.CpmiUser | jq .objects[].name

Note: there is no official API support for locally defined users, so "generic objects" have to be used here.

Last login time is not something we store in the user database (generic objects or not), so you'll have to get it from the logs. Couple threads on this:

0 Kudos

Re: Remote VPN users report

Jump to solution

PhoneBoy,

 

Tried the command, it errored out (image attached).  Am in expert mode.  Here is the error.  Thank you for your time.

 

0 Kudos

Re: Remote VPN users report

Jump to solution
Hello, how i can list 700 users, where i must put the offset command. Thanks in advance.
0 Kudos

Re: Remote VPN users report

Jump to solution
I resolved, with the next command "mgmt_cli -r true --format json show generic-objects class-name com.checkpoint.objects.classes.dummy.CpmiUser limit 500 offset 0 | jq .objects []. Name" but have 760 users, how can I fix it? thanks in advance
0 Kudos
Admin
Admin

Re: Remote VPN users report

Jump to solution
You have to ask for the next 500 results like so:
mgmt_cli -r true --format json show generic-objects class-name com.checkpoint.objects.classes.dummy.CpmiUser limit 500 offset 500 | jq .objects []. Name
0 Kudos

Re: Remote VPN users report

Jump to solution
Thanks for the solution!!
0 Kudos