RQL query for tag-based exception

MarcusHil — Wed, 26 May 2021 11:42:13 GMT

Hi,

I'm trying to help a customer filter out false-positives in the Prisma Cloud policies. For instance, we have a customised "Internet exposed instances" where they previously have white listed specific IP addresses, which is not very dynamic. Instead, we've created tags on all Azure resources in the format of "allowInternetInbound:yes" and I'm trying to figure out how to add that to the RQL statement. In essence, all resources with that tag should not show up in the alerts.

Current RQL: network from vpc.flow_record where src.publicnetwork IN ('Suspicious IPs','Internet IPs') AND source.ip NOT IN (xxx.xx.xx.xx) AND dest.resource IN ( resource where role not in ( 'AWS NAT Gateway' , 'AWS ELB' ) ) and protocol not in ( 'ICMP' , 'ICMP6' )

I've been trying to add to the statement: AND source.resource NOT IN ( resource where tag ( ANY ) IN ( 'allowinboundinternet' ) )

But doesn't seem to work.

Re: RQL query for tag-based exception

AKing9 — Fri, 12 Aug 2022 14:19:09 GMT

Greetings Marcus,

I hope that this note finds you well! I know that it has been a while since you had posted this question but I wanted to see if you still potentially needed any help. Thank you for your time and I hope that you have a good remainder of your day.

Kind Regards,

J. Avery King

topic RQL query for tag-based exception in Prisma Cloud Discussions

RQL query for tag-based exception

Re: RQL query for tag-based exception