This article applies as of PRTG 14

AWS Costs Sensor

With the following script, you can use PRTG to find out how much AWS is charging you for your AWS Cloud infrastructure.

Notes

• You have to have the AWS Tools for Windows PowerShell installed on the probe running this sensor
• The probe service must be allowed to copy data to the directory defined in the $localPath variable
• I would not recommend running this sensor more than twice a day.
• The parameters "-accesskey, -secretkey, -bucket, -localpath" must be set in the settings for this sensor or in the script itself for it to work but you can use some of the placeholders defined in the API under Custom Sensors to fill them out.
• In your AWS account you have to set up Billing Reports and have them sent to the bucket defined in this script.
• The amount of lines that are parsed out of the CSV in the Get-Content command (Line 35) depends on the amount of accounts you have in AWS. You will likely have to turn on billing reports and download one to see which lines are needed for the sensor.
  

param(
# Your account access key - must have read access to your S3 Bucket
$accessKey,
# Your account secret access key
$secretKey,
# The name of your S3 Bucket
$bucket,
# The folder in your bucket to copy, including trailing slash. Leave blank to copy the entire bucket
$keyPrefix,
# The local file path where files should be copied
$localPath = "C:\temp\"
)

#Get all objects from billing bucket
$objects = Get-S3Object -BucketName $bucket -KeyPrefix $keyPrefix -AccessKey $accessKey -SecretKey $secretKey -Region $region 

#Find the newest billing CSV Data
foreach($object in $objects) {
	$changedate = $object.LastModified
    $name = $object.Key
	if ($name -like  "*aws-billing-csv*" -and $changedate -gt (Get-Date).AddDays(-2)) {
		$billingdoc = $object.key
        Copy-S3Object -BucketName $bucket -Key $billingdoc -LocalFile "$localPath$billingdoc" -AccessKey $accessKey -SecretKey $secretKey -Region $region
	}
}



#Setup paths for temp data
$csvPath = $localPath + $billingdoc
$pscsvPath = $localPath + 'aws-billing.csv'

#Parse the lines necessary from the billing statements.  The number of lines depends on the number of accounts associated with the account
Get-Content -Path $csvPath | Select -First 1 | Out-File $pscsvPath
Get-Content -Path $csvPath | select -Last 9 | Out-File $pscsvPath -Append
#Import the newly created parsed CSV
$invoice = import-csv  -Path $pscsvPath | Where-Object {$_.TotalCost -ne ""}
$date = Get-Date

#Write the data for each account into PRTG
Write-Host "<prtg>"

foreach ($record in $invoice){
    [int]$total = $record.TotalCost
    $channelname = $record.LinkedAccountName
        IF([string]::IsNullOrEmpty($channelname)) {
            $channelname = $record.RecordType
            }

    write-host 
            "<result>
<channel>$channelname</channel>
<Unit>Custom</Unit>
<CustomUnit>$</CustomUnit>
<value>$total</value>
</result>"
    }
    write-host "<text>AWS Costs as of $date</text>
</prtg>"