All hands-on labs

Premium Hands-on labintermediateblue teamAWS

Query IAM Credentials Reports with Steampipe

Explore how to leverage Steampipe for querying AWS IAM Credential Reports effectively. The lab demonstrates how to generate credential reports via AWS CLI and then use Steampipe's SQL-like interface to extract actionable security insights. You will learn to write queries that identify root account usage, MFA status, and IAM users with active access keys and console passwords. This practical exercise bridges the gap between raw credential reports and meaningful security analysis.

  • 10 guided tasks
  • Capture the flag
  • Terminal in the browser
  • Video walkthrough

Scenario

IAM credentials reports can be generated via the AWS Console and CLI, but the raw report is hard to query. In this lab, we'll focus on using the open source tool Steampipe to query these reports and gather actionable information we can then use on the job. We'll answer the following questions: Has the root user been accessed recently? Do we have MFA enabled for the root user? Do users have access keys and console passwords? Let's dive in.

What you will learn

  • Generate and download an IAM credential report with the AWS CLI.
  • Install Steampipe and its AWS plugin in a terminal.
  • Query the IAM credential report with SQL in Steampipe.
  • Find out if the root user was used recently and if it has MFA.
  • Find the IAM users that have both a console password and an active access key.
Hands-on lab

Query IAM Credentials Reports with Steampipe

Included in Cybr Premium.