Streamline Your Amazon Bill Format for Engineering with airSlate SignNow

Amazon bill format for Engineering

[Music] [Applause] [Music] hello I'm zad a security Cloud engineer from the AWS office in Cape Town South Africa today I'm going to show you how to retrieve the number of configuration items recorded per month by AWS config to help you understand your AWS config B better let's get started log in to the AWS Management console and open the AWS config console choose settings from the left navigation pen first let's verify that your Amazon simple storage service bucket contains the configuration files delivered by AWS config note the Amazon S3 bucket name listed here now open the Amazon S3 console and navigate to your bucket check to confirm that the bucket contains the conf configuration files next let's create a table in Amazon Athena to query the configuration item data open the Athena console and follow the instructions found in the knowledge Center article to create a new table using the query editor and subsequently run the queries use the following create table statement and replace the placeholder values for your specific S3 bucket name account ID and AWS region note that if you're using Athena engine version 2 and have a large number of resources the configuration data files might exceed the 100 Mb line length limit if this is your situation use the alternative get a table statement instead to I the table by year month and day after the table is created we can run the queries to analyze the configuration item data to get the number of changes per day for given month run this query this query will output the date and number of changes for each day to get the most frequently changed resources which is a best practice when you investigate these issues run this query the query will output the resource type ID change count sorted by most frequently changed to investigate the reason why a specific resource generates a high number of configuration items you can search for the resource under the resource inventory section in the AWS console choose the resources section in the left navigation pin next search for the specific resource using his resource ID or irn and select the resource you can then choose the resource timeline button to show all the configuration changes that occurred for the resource for the last 90 days you can open any of the configuration items and see the Json which will show you exactly what change occurred for a specific time please note when you compare the total number of configuration items between the atheno query results and AWS bilding data for the same month and region you might see a small discrepancy the discrepancy occurs because the data theed can cross their boundaries and include configuration items built in that Jason months and now you know how to retrieve the number of configuration items recorded per month by AWS config to help you understand your AWS config will better thank you for watching and happy cloud computing from all of us here at AWS [Applause] [Music] [Music]