J1 team.. I am wondering if I can put together some analysis of AWS Resources?

Mainly looking at churn like EC2 Instance counts over time. P50/P90 TTL on Ec2 Instances ways to break that down by AWS account etc. Any pro-tips on doing that in J1?


  • dcpeach
    dcpeach ✭✭✭✭✭
    try this query with “include recently deleted” option turned on. This should return you the instances terminated within your soft-deleted data retention period, and the TTL in seconds:
    find aws_instance with state='terminated' as e
    return e.instanceId, e.displayName, (e.stateChangedOn-e.launchedOn)/1000 as TTL
    order by TTL

This Month's Leaders