Google Asset Query (https://console.cloud.google.com/iam-admin/asset-inventory/query) to extract all components for licensing in Wiz

wiz-gcp-discovery.sql

# Google Asset Query (https://console.cloud.google.com/iam-admin/asset-inventory/query)
# This extracts all components for licensing in Wiz
SELECT
  assetType,
  COUNT(*) AS cnt
FROM
  STANDARD_METADATA
WHERE
  assetType IN
  ('compute.googleapis.com/Instance',
    'sqladmin.googleapis.com/Instance',
    'k8s.io/Node',
    'storage.googleapis.com/Bucket',
    'cloudfunctions.googleapis.com/Function',
    'cloudfunctions.googleapis.com/CloudFunction',
    'run.googleapis.com/Service')
GROUP BY
  assetType
ORDER BY
  cnt desc