Query: Show unused services granted a user, role, group, or policy (unused in the last year)

Description

This example helps to identify unused services that have been granted to a user, role, group, or policy, specifically those that have not been used in the past year. This is useful for maintaining security and efficiency by ensuring that unnecessary access permissions are revoked.

Query

Tables used in this query:

• aws_iam_access_advisor

SQL