topic Re: Export information about all group objects to CSV in API / CLI Discussion

Export information about all group objects to CSV

zhangchuang — Mon, 02 Sep 2024 03:20:10 GMT

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?

Re: Export information about all group objects to CSV

PhoneBoy — Tue, 03 Sep 2024 12:44:07 GMT

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-to-a-CSV-file-for/m-p/38841#M2336

Re: Export information about all group objects to CSV

AkosBakos — Tue, 03 Sep 2024 14:02:01 GMT

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

Re: Export information about all group objects to CSV

zhangchuang — Wed, 04 Sep 2024 09:24:42 GMT

Hi AkosBakos,

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

Re: Export information about all group objects to CSV

zhangchuang — Wed, 04 Sep 2024 09:29:31 GMT

Hi PhoneBoy,

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

Re: Export information about all group objects to CSV

PhoneBoy — Wed, 04 Sep 2024 14:18:20 GMT

What I provided a link to was exactly that.