topic Re: Export a .csv of all Network Groups with their members, and all Services Groups with their membe in API / CLI Discussion

Export a .csv of all Network Groups with their members, and all Services Groups with their members

Douglas — Thu, 28 Oct 2021 19:35:08 GMT

Hello all, this seems like it should be easy, but I can't figure it out. I can export a list from the Smart Console, but it doesn't include the members. I ran the command /opt/CPsuite-R80.30/fw1/scripts/web_api_show_package.sh, and it created a file for each policy with a lot more information than I need, and I don't see an option to just export group information.

Is there a way to export a list of just Network Groups and their members? And another list with just Services Groups with their members?

Thanks!

Re: Export a .csv of all Network Groups with their members, and all Services Groups with their membe

PhoneBoy — Thu, 28 Oct 2021 22:48:03 GMT

See: https://community.checkpoint.com/t5/API-CLI-Discussion/CLI-API-Example-for-exporting-importing-and-deleting-different/m-p/40850#M2766

Re: Export a .csv of all Network Groups with their members, and all Services Groups with their membe

Douglas — Fri, 29 Oct 2021 13:28:56 GMT

Thanks PhoneBoy. In the discussion, I see reference to a script named cli_api_export_object_group-members_to_csv.sh, which I think would do what I want, but I can't find in the referenced Github repository.

Re: Export a .csv of all Network Groups with their members, and all Services Groups with their membe

PhoneBoy — Fri, 29 Oct 2021 15:25:57 GMT

It's the first link in the root post for the thread.

Re: Export a .csv of all Network Groups with their members, and all Services Groups with their membe

Douglas — Fri, 29 Oct 2021 18:32:15 GMT

The first link in the root post for the thread eads to the GitHub page for it, which has many different scripts. But I can't find cli_api_export_object_group-members_to_csv.sh

Re: Export a .csv of all Network Groups with their members, and all Services Groups with their membe

the_rock — Fri, 29 Oct 2021 18:46:50 GMT

Thats odd, because I did it few times and it always worked...I just ran ./cli_api_export_objects_to_csv.sh script and it dumped all files in ./dump directory. I see groups there as well, one you are looking for. How did you do this exactly?

Andy