I am trying get a list of all the VM instances only and exclude all GKE instances using the Asset inventory in GCP. I was able to get the details using the query
gcloud asset search-all-resources \
--scope='organizations/<**Organization ID**>' \
--query='NOT labels:goog-gke-node' \
--asset-types='compute.googleapis.com/Instance' \
--order-by='createTime'
I am now trying to get the OS details for all the VM instances. Is there any way we can join the OS table, as it can be done using Azure Resource graph query?
Not able to find a way to add the OS details using Asset inventory query
