Get-CPUUtilisationAllInstancesMultipleAccounts.ps1

Get-CPUUtilisationAllInstancesMultipleAccounts.ps1

$ProfileNames = @(
    "Profile1",
    "Profile2"
)
foreach($Profile in $ProfileNames){
    Set-AWSCredential -ProfileName $Profile
    $StartTime = (Get-Date).AddDays(-30)
    $EndTime = (Get-Date)
    $Period = 60*60 # 1 hr
    $results = @()
    $AccountName = Get-IAMAccountAlias
    foreach($AWSRegion in (Get-AWSRegion).Region){
        $Instances = (Get-EC2Instance -Region $AWSRegion).instances | ?{$_.state.Name -eq 'running'}
        Foreach($Instance in $Instances){
            $InstanceName = ($Instance.tags | ?{$_.key -eq 'Name'}).value
            $Params = @{
                Namespace = 'AWS/EC2' 
                MetricName = 'CPUUtilization' 
                Dimension = @(
                    @{"Name"="InstanceId";Value=$Instance.instanceID} 
                )
                Region = $AWSRegion
                StartTime = $StartTime
                EndTime = $EndTime
                Period = $Period
                Statistic = 'Maximum'
            }
            $stats = Get-CWMetricStatistic @Params
            foreach($metric in $stats.Datapoints){
               $results += $metric | select maximum,timestamp,
                    @{L="InstanceID";E={$Instance.instanceid}},
                    @{L="InstanceName";E={$InstanceName}},
                    @{L="AWSAccount";E={$AccountName}}
            }
        }
    }

    $results | export-csv C:\Users\smartin\Documents\$AccountName.csv
}