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.csvfile 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