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

AaronO
AaronO ✭✭✭
in Asset Management
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?

Answers

  • 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

Categories