https://community.checkpoint.com/t5/Scripts/PSQL-Show-recent-policy-installation-details/m-p/261637#M1238 <P>Awesome!</P> <P>&nbsp;</P> <P><BR />[Expert@CP-MANAGEMENT:0]#<BR />TRING_AGG(DISTINCT CASE WHEN ap.name IS NOT NULL THEN 'Access Control' WHEN tp.name IS NOT NULL THEN 'Threat Prevention' ELSE 'Unclassified' END, ', ') AS policy_types, ipr.statusdescription AS install_status, TO_CHAR(ipr.creationtime, 'YYYY-MM-DD HH24:MI:SS') AS install_time FROM installpolicyresponse ipr LEFT JOIN accesspolicy_data ap ON ipr.policyid = ap.objid LEFT JOIN threatpolicy_data tp ON ipr.policyid = tp.objid LEFT JOIN worksession ws ON ipr.worksession = ws.objid LEFT JOIN domainbase_data d ON ipr.domainid = d.objid LEFT JOIN dleobjectderef_data gw ON ipr.gatewayid = gw.objid AND gw.cpmitable = 'network_objects' AND gw.cpmitype = 'gateway' GROUP BY d.name, ap.name, tp.name, gw.name, ws.username, ws.name, ws.applicationname, ipr.statusdescription, ipr.creationtime ORDER BY ipr.creationtime DESC LIMIT 20;"<BR />domain | policy_package | target | username | session_name | client | policy_types |<BR />install_status | install_time<BR />----------+----------------+--------+--------------+--------------------------+--------------+-------------------+-----<BR />--------------------+---------------------<BR />SMC User | — | — | system_admin | Global Domain Assignment | | Unclassified | Succeeded<BR />| 2025-11-02 10:39:01<BR />SMC User | — | — | system_admin | Global Domain Assignment | | Unclassified | Succeeded<BR />| 2025-11-02 10:39:01<BR />SMC User | — | — | system_admin | Global Domain Assignment | | Unclassified | Succeeded<BR />| 2025-11-02 10:39:01<BR />SMC User | LAB-POLICY | CP-GW | system_admin | Global Domain Assignment | | Threat Prevention | Succ<BR />eeded | 2025-11-02 10:39:01<BR />SMC User | LAB-POLICY | CP-GW | system_admin | Global Domain Assignment | | Access Control | Succ<BR />eeded with Warnings | 2025-11-02 10:39:01<BR />SMC User | LAB-POLICY | — | system_admin | Global Domain Assignment | | Access Control | Succeed<BR />ed | 2025-11-02 10:39:01<BR />SMC User | LAB-POLICY | — | system_admin | Global Domain Assignment | | Access Control | Succeed<BR />ed | 2025-11-02 10:39:01<BR />SMC User | LAB-POLICY | — | system_admin | Global Domain Assignment | | Access Control | Succeed<BR />ed | 2025-11-02 10:39:01<BR />SMC User | LAB-POLICY | — | system_admin | Global Domain Assignment | | Access Control | Succeed<BR />ed | 2025-10-28 10:15:01<BR />SMC User | — | — | system_admin | Global Domain Assignment | | Unclassified | Succeeded<BR />| 2025-10-28 10:15:00<BR />SMC User | — | — | system_admin | Global Domain Assignment | | Unclassified | Succeeded<BR />| 2025-10-28 10:15:00<BR />SMC User | — | — | system_admin | Global Domain Assignment | | Unclassified | Succeeded<BR />| 2025-10-28 10:15:00<BR />SMC User | LAB-POLICY | CP-GW | system_admin | Global Domain Assignment | | Access Control | Succ<BR />eeded with Warnings | 2025-10-28 10:15:00<BR />SMC User | LAB-POLICY | — | system_admin | Global Domain Assignment | | Access Control | Succeed<BR />ed | 2025-10-28 10:15:00<BR />SMC User | LAB-POLICY | — | system_admin | Global Domain Assignment | | Access Control | Succeed<BR />ed | 2025-10-28 10:15:00<BR />SMC User | LAB-POLICY | CP-GW | system_admin | Global Domain Assignment | | Threat Prevention | Succ<BR />eeded | 2025-10-28 10:15:00<BR />SMC User | — | — | admin | admin@27-Oct-2025 | SmartConsole | Unclassified | Succeeded<BR />| 2025-10-27 12:02:13<BR />SMC User | — | — | admin | admin@27-Oct-2025 | SmartConsole | Unclassified | Succeeded<BR />| 2025-10-27 12:02:13<BR />SMC User | — | — | admin | admin@27-Oct-2025 | SmartConsole | Unclassified | Succeeded<BR />| 2025-10-27 12:02:13<BR />SMC User | LAB-POLICY | — | admin | admin@27-Oct-2025 | SmartConsole | Access Control | Succeed<BR />ed | 2025-10-27 12:02:13<BR />(20 rows)</P> <P>[Expert@CP-MANAGEMENT:0]#</P> Sun, 02 Nov 2025 15:40:58 GMT the_rock 2025-11-02T15:40:58Z https://community.checkpoint.com/t5/Scripts/PSQL-Show-recent-policy-installation-details/m-p/261635#M1236 <DIV class=""> <P style="text-align: center;"><span class="lia-unicode-emoji" title=":trophy:">🏆</span>&nbsp;PSQL wizardry!<BR /><span class="lia-unicode-emoji" title=":backhand_index_pointing_right:">👉</span>&nbsp;Directly queries the management database</P> <P><SPAN>PSQL query to show the 20 most recent policy installations on a Check Point Security Management (SmartCenter).<BR /><STRONG>In <U>expert</U> mode run:<BR /></STRONG></SPAN></P> <LI-CODE lang="markup">psql_client cpm postgres -c "SELECT d.name AS domain, COALESCE(ap.name, tp.name, '—') AS policy_package, COALESCE(gw.name, '—') AS target, ws.username, ws.name AS session_name, ws.applicationname AS client, STRING_AGG(DISTINCT CASE WHEN ap.name IS NOT NULL THEN 'Access Control' WHEN tp.name IS NOT NULL THEN 'Threat Prevention' ELSE 'Unclassified' END, ', ') AS policy_types, ipr.statusdescription AS install_status, TO_CHAR(ipr.creationtime, 'YYYY-MM-DD HH24:MI:SS') AS install_time FROM installpolicyresponse ipr LEFT JOIN accesspolicy_data ap ON ipr.policyid = ap.objid LEFT JOIN threatpolicy_data tp ON ipr.policyid = tp.objid LEFT JOIN worksession ws ON ipr.worksession = ws.objid LEFT JOIN domainbase_data d ON ipr.domainid = d.objid LEFT JOIN dleobjectderef_data gw ON ipr.gatewayid = gw.objid AND gw.cpmitable = 'network_objects' AND gw.cpmitype = 'gateway' GROUP BY d.name, ap.name, tp.name, gw.name, ws.username, ws.name, ws.applicationname, ipr.statusdescription, ipr.creationtime ORDER BY ipr.creationtime DESC LIMIT 20;"</LI-CODE></DIV> Sun, 02 Nov 2025 15:27:00 GMT https://community.checkpoint.com/t5/Scripts/PSQL-Show-recent-policy-installation-details/m-p/261635#M1236 Danny 2025-11-02T15:27:00Z https://community.checkpoint.com/t5/Scripts/PSQL-Show-recent-policy-installation-details/m-p/261637#M1238 <P>Awesome!</P> <P>&nbsp;</P> <P><BR />[Expert@CP-MANAGEMENT:0]#<BR />TRING_AGG(DISTINCT CASE WHEN ap.name IS NOT NULL THEN 'Access Control' WHEN tp.name IS NOT NULL THEN 'Threat Prevention' ELSE 'Unclassified' END, ', ') AS policy_types, ipr.statusdescription AS install_status, TO_CHAR(ipr.creationtime, 'YYYY-MM-DD HH24:MI:SS') AS install_time FROM installpolicyresponse ipr LEFT JOIN accesspolicy_data ap ON ipr.policyid = ap.objid LEFT JOIN threatpolicy_data tp ON ipr.policyid = tp.objid LEFT JOIN worksession ws ON ipr.worksession = ws.objid LEFT JOIN domainbase_data d ON ipr.domainid = d.objid LEFT JOIN dleobjectderef_data gw ON ipr.gatewayid = gw.objid AND gw.cpmitable = 'network_objects' AND gw.cpmitype = 'gateway' GROUP BY d.name, ap.name, tp.name, gw.name, ws.username, ws.name, ws.applicationname, ipr.statusdescription, ipr.creationtime ORDER BY ipr.creationtime DESC LIMIT 20;"<BR />domain | policy_package | target | username | session_name | client | policy_types |<BR />install_status | install_time<BR />----------+----------------+--------+--------------+--------------------------+--------------+-------------------+-----<BR />--------------------+---------------------<BR />SMC User | — | — | system_admin | Global Domain Assignment | | Unclassified | Succeeded<BR />| 2025-11-02 10:39:01<BR />SMC User | — | — | system_admin | Global Domain Assignment | | Unclassified | Succeeded<BR />| 2025-11-02 10:39:01<BR />SMC User | — | — | system_admin | Global Domain Assignment | | Unclassified | Succeeded<BR />| 2025-11-02 10:39:01<BR />SMC User | LAB-POLICY | CP-GW | system_admin | Global Domain Assignment | | Threat Prevention | Succ<BR />eeded | 2025-11-02 10:39:01<BR />SMC User | LAB-POLICY | CP-GW | system_admin | Global Domain Assignment | | Access Control | Succ<BR />eeded with Warnings | 2025-11-02 10:39:01<BR />SMC User | LAB-POLICY | — | system_admin | Global Domain Assignment | | Access Control | Succeed<BR />ed | 2025-11-02 10:39:01<BR />SMC User | LAB-POLICY | — | system_admin | Global Domain Assignment | | Access Control | Succeed<BR />ed | 2025-11-02 10:39:01<BR />SMC User | LAB-POLICY | — | system_admin | Global Domain Assignment | | Access Control | Succeed<BR />ed | 2025-11-02 10:39:01<BR />SMC User | LAB-POLICY | — | system_admin | Global Domain Assignment | | Access Control | Succeed<BR />ed | 2025-10-28 10:15:01<BR />SMC User | — | — | system_admin | Global Domain Assignment | | Unclassified | Succeeded<BR />| 2025-10-28 10:15:00<BR />SMC User | — | — | system_admin | Global Domain Assignment | | Unclassified | Succeeded<BR />| 2025-10-28 10:15:00<BR />SMC User | — | — | system_admin | Global Domain Assignment | | Unclassified | Succeeded<BR />| 2025-10-28 10:15:00<BR />SMC User | LAB-POLICY | CP-GW | system_admin | Global Domain Assignment | | Access Control | Succ<BR />eeded with Warnings | 2025-10-28 10:15:00<BR />SMC User | LAB-POLICY | — | system_admin | Global Domain Assignment | | Access Control | Succeed<BR />ed | 2025-10-28 10:15:00<BR />SMC User | LAB-POLICY | — | system_admin | Global Domain Assignment | | Access Control | Succeed<BR />ed | 2025-10-28 10:15:00<BR />SMC User | LAB-POLICY | CP-GW | system_admin | Global Domain Assignment | | Threat Prevention | Succ<BR />eeded | 2025-10-28 10:15:00<BR />SMC User | — | — | admin | admin@27-Oct-2025 | SmartConsole | Unclassified | Succeeded<BR />| 2025-10-27 12:02:13<BR />SMC User | — | — | admin | admin@27-Oct-2025 | SmartConsole | Unclassified | Succeeded<BR />| 2025-10-27 12:02:13<BR />SMC User | — | — | admin | admin@27-Oct-2025 | SmartConsole | Unclassified | Succeeded<BR />| 2025-10-27 12:02:13<BR />SMC User | LAB-POLICY | — | admin | admin@27-Oct-2025 | SmartConsole | Access Control | Succeed<BR />ed | 2025-10-27 12:02:13<BR />(20 rows)</P> <P>[Expert@CP-MANAGEMENT:0]#</P> Sun, 02 Nov 2025 15:40:58 GMT https://community.checkpoint.com/t5/Scripts/PSQL-Show-recent-policy-installation-details/m-p/261637#M1238 the_rock 2025-11-02T15:40:58Z