Find Azure application gateway listeners associated with public IP

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Find Azure application gateway listeners associated with public IP

L0 Member

I think the only method is with this RQL:

config from cloud.resource where cloud.type = 'azure' AND api.name = 'azure-application-gateway' AND json.rule = "['properties.frontendIPConfigurations'][?(@.['properties.publicIPAddress'].id != '')].['properties.httpListeners'].id exists"

However, inside the array you can't put any key value with dots between its characters, so I got error by trying that query. What Can I do?

1 REPLY 1

L1 Bithead

Hello, this can done using RQL joins.

 

Please try the RQL query below.

 

config from cloud.resource where api.name = 'azure-application-gateway' as X; config from cloud.resource where api.name = 'azure-network-public-ip-address' as Y; filter "$.['X'].['properties.frontendIPConfigurations'][*].['properties.publicIPAddress'].['id'] contains $.Y.id"; show Y;

 

Ref: https://docs.paloaltonetworks.com/prisma/prisma-cloud/prisma-cloud-rql-reference/rql-reference/opera...

 

Please let me know if you have any questions or would like to schedule a call to discuss this further.

 

Regards

 

  • 955 Views
  • 1 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!