Who rated this post

🏆 PSQL wizardry!
✔️ Works on all Single Domain Managements
👉 Directly queries the management database

PSQL query to show all centrally managed Check Point systems of a Check Point Security Management (SmartCenter).
In expert mode run:

psql_client monitoring postgres -c "SELECT a.gateway, s.cp_shared_version AS version, MAX(CASE WHEN p.deployment_packages_package_name ~ '(JHF_T|Bundle_T)[0-9]+' THEN 'Take '||REGEXP_REPLACE(p.deployment_packages_package_name, '.*(?:JHF_T|Bundle_T)(\\d+).*', '\\1') ELSE p.deployment_packages_package_name END) package_or_take, a.ip, STRING_AGG(DISTINCT e.family, ', ') AS families, s.fw_policy_name, s.fw_install_time AS last_policy_install FROM alive_gateways a JOIN statuses_view s USING (obj_id) LEFT JOIN entitlement_view e USING (obj_id) LEFT JOIN os_installed_packages_view p USING (obj_id) GROUP BY a.gateway, s.cp_shared_version, a.ip, s.fw_policy_name, s.fw_install_time ORDER BY a.gateway;"

Greetings to: @Kaspars_Zibarts, @Bob_Zimmerman 
Todo: Add support for Multi-Domain Security Managements (MDS)