In the realm of cloud computing, Amazon Web Services (AWS) stands out as a powerhouse, offering a plethora of services tailored to various needs.
Among these services, databases play a pivotal role in storing, managing, and analyzing data. Monitoring and reporting on these databases are crucial for maintaining performance, security, and cost-efficiency. In this blog post, we’ll explore how PowerShell can be harnessed to generate insightful reports on AWS databases, providing administrators with actionable insights.
I am sharing this sample script which you can modify accordingly as per your environment to get the AWS Database Report.
Logic is to assume role, go thru each region and account to find the databases across whole AWS organization.
First download the Amazon RDS Instance Comparison csv from below link, keep in the location from where you will run the script.
https://instances.vantage.sh/rds/
This csv I am using in the script to get pricing.
Prerequisites for this Solution:
Download the script from Git or PowerShell gallery from below links:
Git:
https://github.com/VikasSukhija/Downloads
AWSDataBaseReport.ps1
PowerShell Gallery:
https://www.powershellgallery.com/packages/AWSDataBaseReport
Install-Script -Name AWSDataBaseReport
Update the below section of the script with your own parameters:
This script needs access and secret key of the account that can assume a role that has access to read the AWS Database across the whole organization.
Note: Please secure the access key and secret key as encrypted if you will schedule this script in production.
Script will fetch below details for each AWS database, will generate csv file and send on email.
Here is the Email that email address mentioned in variable will receive.
Here is the CSV report that your will get:
You can modify the script as per your requirements.
Thanks for reading and downloading…
Tech Wizard
https://techwizard.cloud
https://syscloudpro.com/
PowerShell Fast Track