Add table aws_trusted_advisor_check_summary

[khushboo9024]

References
https://pkg.go.dev/github.com/aws/[email protected]/service/support#Support.DescribeTrustedAdvisorCheckSummaries

Note: This table is required to check if AWS Trusted Advisor is enabled with zero checks in alarm state.

[cbruno10]

What is the exact resource this table returns info for? Is it a check summary?

[qualymetrics]

Hello, we need to collect possible public repositories that may contain Access Key and Secret Key and we identified that the item “Exposed Access Keys” via AWS Trusted Advisor could provide this information. Would it be possible to add this table to steampipe?

[github-actions]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[JohannesKonings]

Maybe the table can contain all checks with their status. The calls can be look similar to this: https://gist.github.com/maemichi-monosense/60627feed80a1d13bc08c35a6e6759aa
The summary than could be created via SQL

[ParthaI]

@khushboo9024 @JohannesKonings, I've submitted a PR to address this issue. Would you kindly test it in the PR branch issue-1831?

I wasn't able to personally test the pull request because we lack a business, Enterprise On-Ramp, or Enterprise Support plan, which is required for making the DescribeTrustedAdvisorCheckSummaries API call.

Here are the steps to check out the PR branch:

1. Clone the repository: git clone https://github.com/turbot/steampipe-plugin-aws.git
2. Navigate to the repository: cd steampipe-plugin-aws
3. Switch to the issue-1831 branch: git checkout issue-1831
4. Execute the make command.
5. Run your query.

Thank you!

[JohannesKonings]

The tests for my use case looks good. I got the same numbers for status like the are shown in the AWS console.

[ParthaI]

Thank you, @JohannesKonings, for testing the PR branch and sharing your feedback.

[github-actions]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.