Systems Manager inventory data in a resource-synced centralized bucket: Looking for useful Athena or QuickSight example queries or visualizations to create useful reports and dashboards from the data.


I have setup systems manager inventory within multiple accounts and am using resource sync to copy the inventory to a centralized s3 bucket. I am then using AWS Glue and Athena to create a database and tables based on the inventory data. Everything is working great and I can query the data in Athena just fine.

What I am looking for is if anyone has created useful queries for creating inventory reports that they are willing to share or have a link to? I am basically just trying to not reinvent the wheel. Any queries that provide useful data such as instanceid's and their OS versions, tags, patches installed, etc. Could be anything that you find useful.

Also looking at using Quicksight to view the data and looking for examples there as well.

All AWS and non-AWS articles I have found all show how to implement this system and state then to use Athena and Quicksight to view your data, but I have not found many good examples of the queries or reports. I can spend the time to figure it all out, but would rather get a head start from what others have done.


1 Answer
Accepted Answer


I was able to find the following resources that could help you build a QuickSight dashboard for your AWS Systems Management Inventory data:

Additionally, the following blog articles include QuickSight dashboard examples using data from other AWS services, which you can use as reference when building a QuickSight dashboard for your AWS Systems Management Inventory data:

I hope this information was helpful.

Have a nice day!

answered a year ago
profile picture
reviewed 10 days ago
profile picture
reviewed 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions