search

turbot / steampipe-plugin-gcp

Use SQL to instantly query GCP resources across regions, projects and organizations. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/gcp
Apache License 2.0
39 stars 24 forks source link

Add table gcp_app_engine_application Closes #528 #537

Closed ParthaI closed 7 months ago

ParthaI commented 7 months ago

Integration test logs

Logs ``` N/A ```

Example query results

Results ``` > select * from gcp_app_engine_application +------------+-----------------+----------------------------------------+-------------+--------------------------------+-----------------+------------------------+---------------------------+-----------------------------+------------+----------------+----------------+-> | id | name | service_account | auth_domain | code_bucket | database_type | default_bucket | default_cookie_expiration | default_hostname | gcr_domain | serving_status | dispatch_rules | > +------------+-----------------+----------------------------------------+-------------+--------------------------------+-----------------+------------------------+---------------------------+-----------------------------+------------+----------------+----------------+-> | tester-aaa | apps/tester-aaa | tester-aaa@appspot.gserviceaccount.com | gmail.com | staging.tester-aaa.appspot.com | CLOUD_FIRESTORE | tester-aaa.appspot.com | 0s | tester-aaa.uc.r.appspot.com | us.gcr.io | SERVING | | > +------------+-----------------+----------------------------------------+-------------+--------------------------------+-----------------+------------------------+---------------------------+-----------------------------+------------+----------------+----------------+-> > select a.name, a.service_account, s.email, s.disabled, s.oauth2_client_id, s.iam_policy from gcp_app_engine_application as a, gcp_service_account as s where s.name = a.service_account; +-----------------+----------------------------------------+----------------------------------------+----------+-----------------------+-----------------+ | name | service_account | email | disabled | oauth2_client_id | iam_policy | +-----------------+----------------------------------------+----------------------------------------+----------+-----------------------+-----------------+ | apps/tester-aaa | tester-aaa@appspot.gserviceaccount.com | tester-aaa@appspot.gserviceaccount.com | false | 109440621885192947873 | {"etag":"ACAB"} | +-----------------+----------------------------------------+----------------------------------------+----------+-----------------------+-----------------+ ```