yashafromrussia
/ aws_used_snapshots.sql
Created
May 29, 2024 05:12
steampipe: find used AWS snapshots across all accounts and regions
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| with amis as ( | |
| select | |
| name, | |
| title, | |
| image_id, | |
| creation_date, | |
| state, | |
| region, | |
| jsonb_array_elements(block_device_mappings) -> 'Ebs' ->> 'SnapshotId' as snapshot_ids, | |
| owner_id |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ### Keybase proof | |
| I hereby claim: | |
| * I am yashafromrussia on github. | |
| * I am yashafromrussia (https://keybase.io/yashafromrussia) on keybase. | |
| * I have a public key ASDgGvLR5IrEGWIQJ58aXCdIVaCQrhB6EptVm9eNs43jPwo | |
| To claim this, I am signing this object: |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # This highly available config creates 3 Dgraph Zeros, 3 Dgraph | |
| # Servers with 3 replicas, and 1 Ratel UI client. The Dgraph cluster | |
| # will still be available to service requests even when one Zero | |
| # and/or one Server are down. | |
| # | |
| # There are 4 public services exposed, users can use: | |
| # dgraph-zero-public - To load data using Live & Bulk Loaders | |
| # dgraph-server-public - To connect clients and for HTTP APIs | |
| # dgraph-ratel-public - For Dgraph UI | |
| # dgraph-server-x-http-public - Use for debugging & profiling |