Export information about all group objects to CSV

[zhangchuang]

Is there a way to export all group object information to CSV?
Using 'mgmt_cli - r true show group name' groupname '-- format json | jq'. members [] | [. 'name',. 'subnet4',. 'subnet mask',. 'ipv4 address first',. 'ipv4 address last',. 'ipv4 address'] | @ csv' - r>net_group. csv 'can only export individual group object information.
How do I write it if I want to export the information of all group objects at once?

[PhoneBoy · Accepted solution]

You would have to write a script to iterate through all the groups.
Further, the commands you wrote won’t work of the groups contain more items than a single API call can provide.

You may want to use something like: https://community.checkpoint.com/t5/API-CLI-Discussion/CLI-API-Example-for-exporting-group-members-t...

[zhangchuang]

Hi PhoneBoy,

I see, but I'm not quite sure how to write the script. Could you give me a simple example?

[PhoneBoy]

What I provided a link to was exactly that.

[AkosBakos]

Hi @zhangchuang 

check this: https://support.checkpoint.com/results/sk/sk120342

Here you can export the whole package, and the group members will be in html/xml format in the struckture.

Akos

[zhangchuang]

Hi AkosBakos,

I tried this, but it wasn't that intuitive, I mainly wanted to export it to a table.