Query: Eliminate use of the 'root' user for administrative and daily tasks

Description

This control checks whether the root user has been used in the last 90 days. The control fails if the root user has been used in the last 90 days.

Query

Tables used in this query:

• aws_iam_credential_report

Controls using this query:

• 1.6 Eliminate use of the 'root' user for administrative and daily tasks
• 1.7 Eliminate use of the 'root' user for administrative and daily tasks
• 1.7 Eliminate use of the 'root' user for administrative and daily tasks
• 1.7 Eliminate use of the 'root' user for administrative and daily tasks
• 1.7 Eliminate use of the 'root' user for administrative and daily tasks
• 1.7 Eliminate use of the 'root' user for administrative and daily tasks
• 1.7 Eliminate use of the root user for administrative and daily tasks
• 2.6 Eliminate use of the 'root' user for administrative and daily tasks
• Eliminate use of the 'root' user for administrative and daily tasks

SQL