https://community.checkpoint.com/t5/API-CLI-Discussion/Filter-out-disabled-and-expired-rules-via-API/m-p/182849#M7761 <P>I am querying the CMA rulesbase via API using some filters.</P><P>However, i am not able to filter out disabled or expired rules.</P><P>I can do it in code but i want to minimise number of API calls as my rulebase is pretty big.</P><P>please guide me how can i do using filter in API call.</P><P>API version : 1.7.1 and OS : R80.40</P> Thu, 01 Jun 2023 05:14:05 GMT mahendra 2023-06-01T05:14:05Z https://community.checkpoint.com/t5/API-CLI-Discussion/Filter-out-disabled-and-expired-rules-via-API/m-p/182849#M7761 <P>I am querying the CMA rulesbase via API using some filters.</P><P>However, i am not able to filter out disabled or expired rules.</P><P>I can do it in code but i want to minimise number of API calls as my rulebase is pretty big.</P><P>please guide me how can i do using filter in API call.</P><P>API version : 1.7.1 and OS : R80.40</P> Thu, 01 Jun 2023 05:14:05 GMT https://community.checkpoint.com/t5/API-CLI-Discussion/Filter-out-disabled-and-expired-rules-via-API/m-p/182849#M7761 mahendra 2023-06-01T05:14:05Z https://community.checkpoint.com/t5/API-CLI-Discussion/Filter-out-disabled-and-expired-rules-via-API/m-p/182852#M7763 <P><A href="https://community.checkpoint.com/t5/API-CLI-Discussion/API-command-to-get-the-disable-rule/m-p/87371/highlight/true#M4938" target="_self">Not possible</A>&nbsp;with pure API.<BR />Alternatives:</P> <UL> <LI>use additional script code</LI> <LI>export the rule base as CSV and filter the output</LI> <LI>export the rule base into <A href="https://community.checkpoint.com/t5/API-CLI-Discussion/HowTo-Export-a-Security-Policy-to-Excel/td-p/132296" target="_self">Excel</A> and filter the output</LI> </UL> Thu, 01 Jun 2023 06:15:46 GMT https://community.checkpoint.com/t5/API-CLI-Discussion/Filter-out-disabled-and-expired-rules-via-API/m-p/182852#M7763 Danny 2023-06-01T06:15:46Z