prisma cloud RQL

[C.sasanapuri]

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

[JCalloway4]

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. 

[LMegrelis]

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"