Skip to content

Instantly share code, notes, and snippets.

View stephenVertex's full-sized avatar

Stephen Barr stephenVertex

5 followers · 4 following
View GitHub Profile
@stephenVertex
stephenVertex / cur-query.sql
Created May 12, 2023 17:33
SELECT line_item_resource_id,
line_item_usage_start_date,
line_item_usage_end_date,
line_item_usage_type,
line_item_cost
FROM "your_aws_schema"."your_aws_cur_table"
WHERE line_item_line_item_type = 'Usage'
AND line_item_usage_start_date >= date_trunc('day', current_date - interval '31' DAY)
AND line_item_usage_start_date < date_trunc('day', current_date - interval '1' DAY)
AND line_item_resource_id LIKE '%natgateway%'
@stephenVertex
stephenVertex / vpc-cleanup-idle-nat-gateways.sql
Last active May 12, 2023 17:32
SELECT line_item_resource_id,
line_item_usage_start_date,
line_item_usage_end_date,
line_item_usage_type,
line_item_cost
FROM "your_aws_schema"."your_aws_cur_table"
WHERE line_item_line_item_type = 'Usage'
AND line_item_usage_start_date >= date_trunc('day', current_date - interval '31' DAY)
AND line_item_usage_start_date < date_trunc('day', current_date - interval '1' DAY)
AND line_item_resource_id LIKE '%natgateway%'
@stephenVertex
stephenVertex / vpc-endpoints.org
Created May 7, 2023 17:24

aws ec2 delete-vpc-endpoints –vpc-endpoint-ids vpce-0725b5d5bc12ac9ca

@stephenVertex
stephenVertex / vpc-endpoints.org
Created May 7, 2023 17:24

aws ec2 delete-vpc-endpoints –vpc-endpoint-ids vpce-0725b5d5bc12ac9ca

@stephenVertex
stephenVertex / del.sh
Created May 7, 2023 17:24
aws ec2 delete-vpc-endpoints --vpc-endpoint-ids vpce-0725b5d5bc12ac9ca
@stephenVertex
stephenVertex / vpc-endpoints.org
Created May 7, 2023 17:21

aws ec2 delete-vpc-endpoints –vpc-endpoint-ids vpce-0725b5d5bc12ac9ca

@stephenVertex
stephenVertex / del.sh
Created May 7, 2023 17:20
aws ec2 delete-vpc-endpoints --vpc-endpoint-ids vpce-0725b5d5bc12ac9ca
@stephenVertex
stephenVertex / del-vpc-endpoints.sh
Created May 7, 2023 17:19
aws ec2 delete-vpc-endpoints --vpc-endpoint-ids vpce-0725b5d5bc12ac9ca
@stephenVertex
stephenVertex / vpc-endpoints.org
Last active May 7, 2023 17:01 
{
    "VpcEndpoints": [
        {
            "VpcEndpointId": "vpce-0725b5d5bc12ac9ca",
            "VpcEndpointType": "Interface",
            "VpcId": "vpc-0d6ffa7d6cdd9dae9",
            "ServiceName": "com.amazonaws.us-west-2.s3",
            "State": "Available",
            "PolicyDocument": "{\"Version\":\"2008-10-17\",\"Statement\":[{\"Effect\":\"Allow\",\"Principal\":\"*\",\"Action\":[\"s3:*\"],\"Resource\":[\"*\"]}]}",
@stephenVertex
stephenVertex / vpc-endpoints.org
Created May 7, 2023 16:58

{ “VpcEndpoints”: [ { “VpcEndpointId”: “vpce-0725b5d5bc12ac9ca”, “VpcEndpointType”: “Interface”, “VpcId”: “vpc-0d6ffa7d6cdd9dae9”, “ServiceName”: “com.amazonaws.us-west-2.s3”, “State”: “Available”, “PolicyDocument”: “{"Version":"2008-10-17","Statement":[{"Effect":"Allow","Principal":"","Action":["s3:"],"Resource":["*"]}]}”, “RouteTableIds”: [],