access-policy-name details for all gateways and clusters

[ram_kum]

Hello checkpoint guru's,

i am running below command which gives me cluster name, cluster ip-address, cluster members but unable to get access-policy-name details, what am i doing wrong here?

cmd:

[Expert@checkpoint-server:0]# mgmt_cli show gateways-and-servers details-level full -r true -f json limit 10 | jq '.objects[] | select( .type == "CpmiVsClusterNetobj" ) | [."name",."ipv4-address",."access-policy-name" ,."cluster-member-names"[]] | @csv' -r

"chp-fw2v","10.x.x.x",,"chp-fwvsx2a-mgmt_chp-fw2v","chp-fwvsx2b-mgmt_chp-fw2v"

json format output:

{

  "objects" : [ {

    "uid" : "a09396ea-4f28-4b9a-b82a-d831796c3368",

    "name" : "chp-fw2v",

    "type" : "CpmiVsClusterNetobj",

    "domain" : {

      "uid" : "57854616-014e-b34c-8fb2-a851ad1c6bda",

      "name" : "Admin",

      "domain-type" : "domain"

    },

    "policy" : {

      "access-policy-installed" : true,

      "access-policy-name" : "outer-policy",

      "access-policy-installation-date" : {

        "posix" : 1676495853500,

        "iso-8601" : "2023-02-15T21:17+0000"

      },

      "threat-policy-installed" : false

[PhoneBoy · Accepted solution]

You’re referring to .”access-policy-name” in your jq query when you should be referring to .policy.”access-policy-name” 

[ram_kum]

oh ok, access-policy-name is nested to policy didnt observe that, thanks @PhoneBoy .

how about if i want to search with .type == access-policy-name "outer-policy" instead of  .type == "CpmiVsClusterNetobj", my goal is to get cluster name, cluster ip-address, cluster members using policy-name

[PhoneBoy]

I presume you'd also search for .policy."access-policy-name" as well.
However, I have not used the search function in jq.