Getting Credential Reports for your AWS Account

By Ashwin Venugopal -





Understanding the Report Format

Credential reports are formatted in Comma-Separated Values (CSV) files and they contain following columns:
  1. user- The friendly name of the user.
  2. arn- The Amazon Resource Name (ARN) of the user.
  3. user_creation_time- The date and time when a user was created, in ISO 8601 date-time format.
  4. password_enabled- This value is True when a user has a password, otherwise it's False. However, for AWS account root user, the value is not_supported.
  5. password_last_used- Date and time at which the IAM user's as well as the AWS account root user's password was last used, in ISO 8601 date-time format.
  6. password_last_changed- The date and time at which the user's password was last set (in ISO 8601 date-time format).
  7. password_next_rotation- This one also shows the date and time at which the user is required to set a new password (in ISO 8601 date-time format).
  8. mfa_active- If an MFA device is enabled for a user, then, this value is True otherwise it's False.
  9. access_key_1_active- If the access key is active, then, the value is True otherwise it's False. 
  10. access_key_1_last_rotated- It contains the date and time (in ISO 8601 date-time format) at which the access key was last created or changed. It's N/A if there's no access key.
  11. access_key_1_last_used_date- The date and time at which the user's was most recently used to sign an AWS API request.
  12. access_key_1_last_used_region- The AWS Region in which the access key was most recently used.
  13. access_key_1_last_used_service- The most recently accessed AWS service with the access key.
  14. access_key_2_active- If there's a second access key and it's Active this value is True otherwise False.
  15. access_key_2_last_rotated- The date and time at which the second access key was created or last changed.
  16. access_key_2_last_used_date- The date and time at which the second access key was most recently used to sign an AWS API request.
  17. access_key_2_last_used_region- The AWS Region in which the user's second access key was most recently used.
  18. cert_1_active- If the user's X.509 signing certificate's status is Active, then, this value is True otherwise it's False.
  19. cert_1_last_rotated- It's the date and time when the user's signing certificate was created or last changed.
  20. cert_2_active- If the user's second X.509 signing certificate's status is Active, then, this value is True otherwise it's False.
  21. cert_2_last_rotated- It's the date and time when the user's second signing certificate was created or last changed.

Getting Credential Reports (Console)

The AWS Management Console can help in downloading a credential report as a CSV file.

To download a credential report (console)

  1. Firstly, sign-in to the AWS Management Console and open the IAM console at https://console.aws.amazon.com/iam/.
  2. Now, select Credential Report in the navigation pane.
  3. After that you can go for Download Report.

Getting Credential Reports (AWS CLI)

To download a credentials report (AWS CLI)
  1. First of all, generate a credentials report and as AWS only stores a single report, the new one will overwrite the previous one. aws iam generate_credential_report.
  2. Now, you can view the last generated report: aws iam get_credential_report.

Getting Credential Reports (AWS API)

To download a credentials report (AWS API)
  1. First of all, generate a credentials report and as AWS only stores a single report, the new one will overwrite the previous one. GenerateCredentialReport.
  2. Now, you can view the last generated report: GetCredentialReport.























































Comments

Post a Comment

Popular posts from this blog

Query, Visualize, & Monitor Data in Azure Sentinel

By Ashwin Venugopal -
Image
  Azure Sentinel Workbooks Several ready for use templates are provided by the Azure Sentinel that can be used to create your own workbook and then modify them as needed for Contoso. Most of the data connectors it uses to ingest data come with their own workbooks, but better insight can be obtained by simply looking into the data that is being ingested by using tables and visualizations, including bar and pie charts. You can also make your own workbook easily by using this data from the beginning instead of using the predefined templates. Workbook Page You can easily access the workbook page from the Azure Sentinel from the navigation pane which consists of the: Workbook header- You can add a new workbook and review the saved workbooks as well as templates that are available on the workbook page. Templates section- You can access existing workbook templates on the Templates tab. You can save some of the workbooks for quick access and they will appear on the My Workbooks tab.  From the
Read more

Planning for Implementing SAP Solutions on Azure (Part 2 of 5)

By Ashwin Venugopal -
Image
  To read part 1 please click  here To read part 3 please click  here To read part 4 please click  here To read part 5 please click  here Load Balancing The load balancer uses probe ports to determine as well as route the traffic to an active DBMS node, but of there's any failover then the most common SAP application architecture can automatically reconnect against the private virtual IP address without the need for the SAP application to reconfigure it, while the load balancer redirect the traffic against the private virtual IP address without any need for the SAP application to reconfigure. The loaf balancer also offers an option of DirectServerReturn which if configured, can help in directing the traffic from the DBMS VM to the SAP application layer directly to the application layer without routing through the load balancer. But, if it isn't configured, then the return traffic to the SAP application layer is routed through the load balancer. You can also use Azure Load Balan
Read more

Work with String Data Using KQL Statements

By Ashwin Venugopal -
Image
  Extract Data from Unstructured String Fields Unstructured string fields often contains the Security log data and requires parsing to extract data. There are multiple ways of pulling information from string fields in KQL and the two primary operators used are extract and parse.  Extract It gets a match for a regular expression from a text string. You can convert the extracted substring to the indicated type.  Arguments regex- A regular expression. captureGroup- A positive int constant indicating the capture group to extract. 0 stands for the entire match, 1 for the value matched by the first '('parenthesis')' in the regular expression, 2 or more for subsequent parenthesis.  text- A string to search. typeLiteral- An optional type literal. If provided, the extracted substring is converted to this type.  Returns If regex finds a match in text- the substring matched against the indicated capture group captureGroup, optionally converted to typeLiteral. If there's no mat
Read more