<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic mgmt_cli to delete all objects matching a pattern in API / CLI Discussion</title>
    <link>https://community.checkpoint.com/t5/API-CLI-Discussion/mgmt-cli-to-delete-all-objects-matching-a-pattern/m-p/75217#M4382</link>
    <description>&lt;P&gt;This came across my mail from an internal source and it's too good not to share.&lt;/P&gt;
&lt;P&gt;A small bit of scripting with show-objects and delete-batch-objects can remove all objects (up to the 500 object limit of show-objects) based on a pattern.&lt;/P&gt;
&lt;P class="lia-indent-padding-left-30px"&gt;&lt;FONT face="courier new,courier"&gt;&lt;STRONG&gt;mgmt_cli login -u aa -p aaaa &amp;gt; /tmp/sid.txt.$$&lt;BR /&gt;&lt;/STRONG&gt;&lt;STRONG&gt;mgmt_cli -s /tmp/sid.txt.$$ delete objects-batch objects.1.type group&lt;/STRONG&gt;&lt;STRONG&gt; $(mgmt_cli -s /tmp/sid.txt.$$ -f json show objects filter test-group- limit 500 | jq '.objects[].name' | cat -n | sed -r 's/^\s+([0-9]+)/objects.1.list.\1.name/' | tr '\n' ' ')&lt;BR /&gt;&lt;/STRONG&gt;&lt;STRONG&gt;mgmt_cli -s /tmp/sid.txt.$$ publish&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;Explanation of commands:&lt;/P&gt;
&lt;TABLE&gt;
&lt;TBODY&gt;
&lt;TR&gt;
&lt;TD width="631"&gt;
&lt;P&gt;&lt;STRONG&gt;mgmt_cli -s /tmp/sid.txt.$$ delete objects-batch objects.1.type host&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="612"&gt;
&lt;P&gt;Perform batch delete on the results of the next rows&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="631"&gt;
&lt;P&gt;&lt;STRONG&gt;$(…)&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="612"&gt;
&lt;P&gt;Treat the output of the command in parenthesis as command line arguments&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="631"&gt;
&lt;P&gt;&lt;STRONG&gt;mgmt_cli -s /tmp/sid.txt.$$ -f json show-objects filter test-host- limit 500&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="612"&gt;
&lt;P&gt;Get objects containing &lt;STRONG&gt;test-host-&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="631"&gt;
&lt;P&gt;&lt;STRONG&gt;jq '.objects[].name'&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="612"&gt;
&lt;P&gt;Get the object names&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="631"&gt;
&lt;P&gt;&lt;STRONG&gt;cat -n&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="612"&gt;
&lt;P&gt;Add a line number to each name&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="631"&gt;
&lt;P&gt;&lt;STRONG&gt;sed -r 's/^\s+([0-9]+)/objects.1.list.\1.name/'&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="612"&gt;
&lt;P&gt;Replace each line number &lt;EM&gt;n&lt;/EM&gt; with objects.1.list.&lt;EM&gt;n&lt;/EM&gt;.name&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="631"&gt;
&lt;P&gt;&lt;STRONG&gt;tr '\n' ' '&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="612"&gt;
&lt;P&gt;Put all the separate lines together on the same line as input to the delete-objects-batch command&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;/TBODY&gt;
&lt;/TABLE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Thu, 13 Feb 2020 21:24:49 GMT</pubDate>
    <dc:creator>PhoneBoy</dc:creator>
    <dc:date>2020-02-13T21:24:49Z</dc:date>
    <item>
      <title>mgmt_cli to delete all objects matching a pattern</title>
      <link>https://community.checkpoint.com/t5/API-CLI-Discussion/mgmt-cli-to-delete-all-objects-matching-a-pattern/m-p/75217#M4382</link>
      <description>&lt;P&gt;This came across my mail from an internal source and it's too good not to share.&lt;/P&gt;
&lt;P&gt;A small bit of scripting with show-objects and delete-batch-objects can remove all objects (up to the 500 object limit of show-objects) based on a pattern.&lt;/P&gt;
&lt;P class="lia-indent-padding-left-30px"&gt;&lt;FONT face="courier new,courier"&gt;&lt;STRONG&gt;mgmt_cli login -u aa -p aaaa &amp;gt; /tmp/sid.txt.$$&lt;BR /&gt;&lt;/STRONG&gt;&lt;STRONG&gt;mgmt_cli -s /tmp/sid.txt.$$ delete objects-batch objects.1.type group&lt;/STRONG&gt;&lt;STRONG&gt; $(mgmt_cli -s /tmp/sid.txt.$$ -f json show objects filter test-group- limit 500 | jq '.objects[].name' | cat -n | sed -r 's/^\s+([0-9]+)/objects.1.list.\1.name/' | tr '\n' ' ')&lt;BR /&gt;&lt;/STRONG&gt;&lt;STRONG&gt;mgmt_cli -s /tmp/sid.txt.$$ publish&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;Explanation of commands:&lt;/P&gt;
&lt;TABLE&gt;
&lt;TBODY&gt;
&lt;TR&gt;
&lt;TD width="631"&gt;
&lt;P&gt;&lt;STRONG&gt;mgmt_cli -s /tmp/sid.txt.$$ delete objects-batch objects.1.type host&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="612"&gt;
&lt;P&gt;Perform batch delete on the results of the next rows&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="631"&gt;
&lt;P&gt;&lt;STRONG&gt;$(…)&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="612"&gt;
&lt;P&gt;Treat the output of the command in parenthesis as command line arguments&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="631"&gt;
&lt;P&gt;&lt;STRONG&gt;mgmt_cli -s /tmp/sid.txt.$$ -f json show-objects filter test-host- limit 500&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="612"&gt;
&lt;P&gt;Get objects containing &lt;STRONG&gt;test-host-&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="631"&gt;
&lt;P&gt;&lt;STRONG&gt;jq '.objects[].name'&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="612"&gt;
&lt;P&gt;Get the object names&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="631"&gt;
&lt;P&gt;&lt;STRONG&gt;cat -n&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="612"&gt;
&lt;P&gt;Add a line number to each name&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="631"&gt;
&lt;P&gt;&lt;STRONG&gt;sed -r 's/^\s+([0-9]+)/objects.1.list.\1.name/'&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="612"&gt;
&lt;P&gt;Replace each line number &lt;EM&gt;n&lt;/EM&gt; with objects.1.list.&lt;EM&gt;n&lt;/EM&gt;.name&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="631"&gt;
&lt;P&gt;&lt;STRONG&gt;tr '\n' ' '&lt;/STRONG&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;TD width="612"&gt;
&lt;P&gt;Put all the separate lines together on the same line as input to the delete-objects-batch command&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;/TBODY&gt;
&lt;/TABLE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 13 Feb 2020 21:24:49 GMT</pubDate>
      <guid>https://community.checkpoint.com/t5/API-CLI-Discussion/mgmt-cli-to-delete-all-objects-matching-a-pattern/m-p/75217#M4382</guid>
      <dc:creator>PhoneBoy</dc:creator>
      <dc:date>2020-02-13T21:24:49Z</dc:date>
    </item>
  </channel>
</rss>

