Skip to Content
Using AlertDAWS Queries

AWS Queries

AlertD lets you query your AWS infrastructure using natural language. This page lists verified example queries by service, and the full list of supported AWS services.

Example Queries by Service

EC2 (Elastic Compute Cloud)

  • List all EC2 instances in us-west-2
  • Which instances have CPU above 80%?
  • Can we downsize any underutilized EC2 instances?
  • List all EC2 instances in 10.74.50.0/24 using public IPs
  • Show me EC2 instances with disk I/O issues

EBS (Elastic Block Store)

  • Which EBS volumes are unattached?
  • List all unencrypted EBS volumes
  • Are any volumes consistently at max throughput?
  • Which volumes don’t have snapshots?

S3 (Simple Storage Service)

  • Are any of our S3 buckets public?
  • Which S3 buckets haven’t been accessed in 30 days?
  • What files above 1 GB are there in my S3 buckets?
  • Group S3 buckets by region

RDS & Aurora

  • What’s causing replication lag on my Aurora read replicas?
  • Which RDS instances are underutilized and could be right-sized?
  • Have we enabled audit logging on our Aurora clusters?
  • Which databases have automated backups disabled?

IAM (Identity and Access Management)

  • Are there IAM users with admin privileges who haven’t logged in recently?
  • List all IAM users without MFA
  • Do our CloudWatch logs show any “Access Denied” events?

DynamoDB

  • Which DynamoDB tables are costing me the most money?
  • Are there tables with provisioned capacity that are barely used?
  • Which tables have high read/write throttling?

Route 53

  • List all A records across my hosted zones
  • Are there any duplicate DNS entries for the same domain?
  • Show me failing health checks

CloudWatch

  • Show me all CloudWatch alarms in ALARM state
  • Which metrics have breached thresholds?
  • Show me recent CloudWatch log errors

VPC & Networking

  • Which security groups allow 0.0.0.0/0 access?
  • List all VPCs and their CIDR blocks
  • Show me all public subnets

Supported AWS Services

For the full list of ingested AWS services and resource types, see the Supported AWS Services reference page.

Next Steps

Last updated on
Advanced ModeAnalyzing Results