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_cloud_asset Closes #484 #532

Closed ParthaI closed 7 months ago

ParthaI commented 7 months ago

Integration test logs

Logs ``` N/A ```

Example query results

Results ``` select name, asset_type, update_time, ancestors from gcp_cloud_asset_inventory limit 5; [ { "ancestors": [ "projects/33333333333", "folders/3333334444", "folders/973319786971", "organizations/33333355555" ], "asset_type": "apikeys.googleapis.com/Key", "name": "//apikeys.googleapis.com/projects/33333333333/locations/global/keys/1b871ce5-0fe8-43f8-8be7-c17412df8765", "update_time": "2023-11-24T13:35:25+05:30" }, { "ancestors": [ "projects/33333333333", "folders/3333334444", "folders/973319786971", "organizations/33333355555" ], "asset_type": "apikeys.googleapis.com/Key", "name": "//apikeys.googleapis.com/projects/33333333333/locations/global/keys/80bd9a2a-1133-41be-8c2f-90793640dece", "update_time": "2023-11-27T19:36:05+05:30" }, { "ancestors": [ "projects/33333333333", "folders/3333334444", "folders/973319786971", "organizations/33333355555" ], "asset_type": "apikeys.googleapis.com/Key", "name": "//apikeys.googleapis.com/projects/33333333333/locations/global/keys/6053ca53-2666-46dd-99df-2ee9c557f6cf", "update_time": "2023-10-19T12:36:27+05:30" }, { "ancestors": [ "projects/33333333333", "folders/3333334444", "folders/973319786971", "organizations/33333355555" ], "asset_type": "aiplatform.googleapis.com/Endpoint", "name": "//aiplatform.googleapis.com/projects/33333333333/locations/us-central1/endpoints/5580736193521254400", "update_time": "2023-09-11T23:15:23+05:30" }, { "ancestors": [ "projects/33333333333", "folders/3333334444", "folders/973319786971", "organizations/33333355555" ], "asset_type": "apikeys.googleapis.com/Key", "name": "//apikeys.googleapis.com/projects/33333333333/locations/global/keys/41d0591d-720a-43bc-bf58-38fe7fdd52f4", "update_time": "2023-07-25T11:34:46+05:30" } ] ```