Intermediatereporting

Dev-Test Resource Cost Chef - Comprehensive Audit Suite for AWS, Azure, GCP & OCI

PowerShell and Python scripts that perform comprehensive audits of dev/test environments across all major cloud providers. Detects premium SKUs, oversized VMs, orphaned resources, security issues, and missing automation tags.

⏱️ Prep Time:Perfect risotto done
🧩 Difficulty:Intermediate

πŸ” What It Does

  • πŸ” Detects premium SKUs and tiers across all services (App Services, SQL Databases, Redis, RDS, ElastiCache, Cloud SQL, etc.)
  • πŸ“ Identifies oversized VMs and compute instances inappropriate for dev/test workloads
  • ⏰ Flags resources missing automation tags and scheduling for off-hours cost savings
  • πŸ§Ÿβ€β™‚οΈ Hunts down orphaned resources (disks, volumes, IPs, load balancers) still generating costs
  • πŸ›‘οΈ Identifies permissive security configurations that could lead to security risks
  • πŸ“Š Generates both CSV exports and beautiful HTML reports with cloud-specific styling
  • 🌐 Works across AWS, Azure, GCP, and OCI with a consistent methodology and output format

βš™οΈ Requirements Checklist

  • βœ… PowerShell 5.1+ (or Core 7+) with internet access for Azure and AWS scripts
  • βœ… Python 3.6+ for OCI script with oci, pandas, jinja2, and matplotlib packages
  • βœ… Azure modules: Az.Accounts, Az.Resources (auto-installed if missing)
  • βœ… AWS modules: AWS.Tools.Common, AWS.Tools.EC2, AWS.Tools.RDS (auto-installed if missing)
  • βœ… GCP modules: GoogleCloud (auto-installed if missing)
  • βœ… Read-only permissions to resources, tags, and cost data across your cloud accounts
  • βœ… 5-10 minutes runtime depending on environment size and cloud provider

πŸ“Œ Talk Nerdy Tip:

Dev environments are like test kitchensβ€”they don't need premium ingredients or industrial equipment to create great recipes. Downgrade those premium SKUs and right-size those oversized VMs! πŸ‘¨β€πŸ³

multi-cloudcost-optimizationawsazuregcpocidev-testaudit