AWS profile

AWS Inventory

Export AWS resources across regions to Excel.

Description

The AWS Inventory tool queries AWS across one or more regions and exports a multi-tab Excel report of all resources. It collects information about EC2 instances, VPCs, subnets, security groups, load balancers, S3 buckets, RDS databases, and other AWS resources. This tool is useful for infrastructure auditing, cost analysis, and compliance reporting.

Input

This tool requires:

  • devices.csv file with columns: host, device_type
  • SSH credentials (username and password prompted at runtime)
  • Output folder name (prompted at runtime)

Usage

Run the toolkit and select option [7] from the menu:

Terminal
docker compose run network_automation

Output

Results are saved to:

outputs/aws_inventory//

Each run produces:

  • CSV files - One per device
  • JSON files - Raw parsed output from each device
  • Excel summary report - Consolidated data across all devices

Standalone Usage

To run this tool directly without the run.py menu:

Terminal
cd tools/cloud_automation/aws-grep && python aws_inventory.py --profile lab