topic Re: prisma cloud RQL in Prisma Cloud Discussions

prisma cloud RQL

C.sasanapuri — Thu, 17 Apr 2025 05:36:23 GMT

Can any one know how to check RQL for how many VM's are onboarded present day in GCP?

Re: prisma cloud RQL

JCalloway4 — Thu, 17 Apr 2025 12:38:33 GMT

Hello!
If all you're trying to do is count the number of VM's (Compute instances) that are in GCP, than this one will do it:

config from cloud.resource where api.name = 'gcloud-compute-instances-list'

However, I'm not really sure what you mean by "Onboarded", as Cloud Accounts are onboarded, VM's are just detected. Give this a shot and reply back if you need something more specific.

Re: prisma cloud RQL

LMegrelis — Thu, 24 Apr 2025 15:02:13 GMT

Hello!

And if you want to get more specific you can add a json.rule parameter to see which VMs are running, etc.

config from cloud.resource where api.name = 'gcloud-compute-instances-list' AND json.rule = status equals "RUNNING"