Trusted Remediator integration with Quick - AMS Accelerate User Guide
Add a new dataset for the Remediation item logAdd a new dataset for the Automated remediation execution log

Trusted Remediator integration with Quick

You can integrate the Trusted Remediator logs stored in Amazon S3 with Quick to build customized remediation report. Quick integration is optional. This feature allows you to use the logs to build custom reporting dashboards. To obtain on-request reports for Trusted Remediator, contact your CSDM. For more information on available Trusted Remediator reports, see Trusted Remediator reports.

For more information on visualizing data in Quick, see Visualizing data in Quick.

Add a dataset to Quick for the Remediation item log

To add a dataset to Quick for the Remediation item log, follow these steps:

  1. Log in to Quick console. You can create the Quick report in any AWS Region that Quick supports. However, for better performance and lower costs, it's a best practice to create the report in the Region where the Trusted Remediator logging bucket is located.

  2. Choose Datasets.

  3. Choose S3.

  4. In the New S3 data source, enter the following values:

    • Data source name: trusted-remediator-delegated_administrator_account_id-account_region-remediation-items.

    • Upload a manifest file: Create a JSON file with the following content, and use it. When creating the file, replace logging_bucket_name in the URIPrefixes key.

      {
    "fileLocations": [
        {
            "URIPrefixes": [
                "s3://{logging_bucket_name}/remediation_items/"
            ]
        }
    ],
    "globalUploadSettings": {
        "format": "JSON",
        "delimiter": ",",
        "textqualifier": "'",
        "containsHeader": "true"
    }
}

    • Choose Connect.

    • From the Finish dataset creation window, choose Visualize.

    • Quick opens the new analysis sheet page. You are now ready to create a new analysis using the Remediation item log.

The following is a sample analysis:

A sample analysis worksheet.

Add a dataset to Quick for the Automated remediation execution log

  1. Log in to Quick console. You can create the Quick report in any AWS Region that Quick supports. However, for better performance and lower costs, it's a best practice to create the report in the Region where the Trusted Remediator logging bucket is located.

  2. Choose Datasets.

  3. Choose S3.

  4. In the New S3 data source, enter the following values:

    • Data source name: trusted-remediator-delegated_administrator_account_id-account_region-remediation-executions.

    • Upload a manifest file: Create a JSON file with the following content, and then use this file. When creating the file, replace logging_bucket_name in the URIPrefixes key.

      {
    "fileLocations": [
        {
            "URIPrefixes": [
                "s3://{logging_bucket_name}/remediation_executions/"
            ]
        }
    ],
    "globalUploadSettings": {
        "format": "JSON",
        "delimiter": ",",
        "textqualifier": "'",
        "containsHeader": "true"
    }
}

    • Choose Connect.

    • From the Finish dataset creation window, choose Visualize.

    • Quick opens the new analysis sheet page. You are now ready to create a new analysis using the Remediation item log.

The following is a sample analysis:

A sample analysis worksheet.