Example dashboard charts and layout for AWS Resources:
The above example contains the following charts/queries:
EC2 Instances 
(Left) Number of Active EC2 Instances by Account
Chart type: pie
Query:
Find aws_instance with active=true as e return e.tag.AccountName as name, count(e) as value
(Right) Recently terminated EC2 instances by account
Chart type: bar
Query:
Find aws_instance with state='terminated' as i return i.tag.AccountName as x, count(i) as y
ENI network interfaces 
(Left) ENI Count by Account
Chart type: pie
Query:
Find aws_eni as e return e.tag.AccountName as name, count(e) as value
(Right) ENI Count by Account
Chart type: bar
Query:
Find aws_eni as e return e.tag.AccountName as x, count(e) as y
AMI usage by image name 
Chart type: pie
Query:
Find aws_instance as h that uses aws_ami as a return a.displayName as name, count(h) as value
Unused EBS volumes by account 
Chart type: bar
Query:
Find aws_ebs_volume as v that !uses aws_instance return v.tag.AccountName as x, count(v) as y
Lambda serverless functions 
(Left) Lambda functions by runtime (all functions)
Chart type: pie
Query:
Find aws_lambda_function as f Return f.runtime as name, count(f) as value
(Middle) Lambda functions not attached to a VPC by account
Chart type: pie
Query:
Find aws_lambda_function with vpcId=undefined or vpcId='' as f Return f.tag.AccountName as name, count(f) as value
(Right) Number of lambda functions by VPC
Chart type: pie
Query:
Find aws_lambda_function as f that HAS aws_vpc as v Return v.name as name, count(f) as value
Storage (S3 and Dynamo) 
(Left) Number of S3 buckets by account
Chart type: pie
Query:
FIND aws_s3_bucket as bkt RETURN bkt.tag.AccountName AS name, count(bkt) AS value
(Right) Number of DynamoDb Tables by Account
Chart type: pie
Query:
Find aws_dynamodb_table as e return e.tag.AccountName as name, count(e) as value
RDS databases 
(Left) RDS instances count by size
Chart type: bar
Query:
find aws_db_instance as i return i.dbInstanceClass as x, count(i) as y
(Right) Production RDS instances count by cluster name
Chart type: pie
Query:
Find aws_rds_cluster with tag.Production=true as c that contains aws_db_instance as i return c.displayName as name, count(i) as value
Comments
0 comments
Please sign in to leave a comment.