topic Re: How to write RQL to list out the cloud account & account group details with the below query in Prisma Cloud Discussions

How to write RQL to list out the cloud account & account group details with the below query

MPalagiri — Wed, 02 Sep 2020 18:07:02 GMT

Hi Friends,

I wanted to look out the traffic where FTP/SSH port enabled from an internet/suspicious IP's to internal network.With the below query i am able to see the connection details.

network where dest.port IN ( 21,22 ) AND source.publicnetwork IN ( 'Internet IPs' ) AND traffic.type IN ( 'ACCEPTED' )

But along with these i wanted to export the details of which firewall it's or region of cloud account or account group so that i can able to take action quickly.

Can someone please explain how to write RQL query to list out the account group & firewall details along with cloud accounts..If someone explain query to fetch custom fields it would be highly appreciated.

Thank you somuch.

Re: How to write RQL to list out the cloud account & account group details with the below query

AKing9 — Tue, 16 Aug 2022 20:54:14 GMT

Greetings MPalagiri,

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

Re: How to write RQL to list out the cloud account & account group details with the below query

BCastillo — Wed, 14 Sep 2022 00:26:48 GMT

Hello there,

Please try running the RQL again. There have been a few updates to Prisma cloud. Once the results are displayed, click on the instance in question. On the right side you will see Instance Summary: this will consist of the Account Name and Region to best assist with quick action. Also, for your firewall search. What cloud account would you like to pull the firewalls from? Also, what type of firewalls would you like to pull: nacls or sgs?