topic Re: How to list and export the objects member from the network group in checkpoint smartconsole R80. in API / CLI Discussion

How to list and export the objects member from the network group in checkpoint smartconsole R80.40

NISUKSUPPORT — Fri, 27 May 2022 15:16:27 GMT

How to list and export the objects member from the network group in checkpoint smartconsole R80.40 or in GAIA R80.40

Re: How to list and export the objects member from the network group in checkpoint smartconsole R80.

PhoneBoy — Fri, 27 May 2022 21:19:37 GMT

It entirely depends on what is in the group and what precise details you need from said group.
If you want just the names of the objects in said group, something like:

mgmt_cli -r true show-group name "groupname" --format json | jq '.members[] | [.name] |@csv' -r

Or you can use a script like the following: https://community.checkpoint.com/t5/API-CLI-Discussion/CLI-API-Example-for-exporting-importing-and-deleting-different/m-p/40850#M2766

Re: How to list and export the objects member from the network group in checkpoint smartconsole R80.

Exonix — Mon, 29 Aug 2022 13:17:44 GMT

I'm getting an error:

[Expert@ws01:0]# mgmt_cli -r true show-group name "Group1" --format json | jq '.members[] | [.name] |@csv' -r
parse error: Invalid numeric literal at line 1, column 9
Logout failed

what is wrong?

Re: How to list and export the objects member from the network group in checkpoint smartconsole R80.

PhoneBoy — Mon, 29 Aug 2022 18:32:02 GMT

What is the output of: mgmt_cli -r true show-group name "Group1" --format json

Re: How to list and export the objects member from the network group in checkpoint smartconsole R80.

Uj4ng — Thu, 02 Mar 2023 11:03:08 GMT

And what if I want to export the users object complete with authentication methods?

Re: How to list and export the objects member from the network group in checkpoint smartconsole R80.

PhoneBoy — Thu, 02 Mar 2023 16:12:26 GMT

To get the name and authentication method, I imagine something like

mgmt_cli -r true show-users details-level full --format json | jq '.objects[] | [.name] [."authentication-method"] |@csv' -r

If you want additional details to be included, then you would modify the jq portion of the CLI command accordingly.
You can see the fields available here: https://sc1.checkpoint.com/documents/latest/APIs/index.html#cli/show-users~v1.9%20
Also, if you have lots of users, you may have to issue this command multiple times using the offset parameter to request the next set of results.