Create a dashboard with the AWS CLI

Run the create-dashboard to create a dashboard.

When you create a custom dashboard, you can pass in an array with up to 10 widgets. A widget provides a graphical representation of the results for a query. Each widget consists of ViewProperties, QueryStatement, and QueryParameters.

The following example creates a dashboard with four widgets, one of each view type.

aws cloudtrail create-dashboard --name AccountActivityDashboard \
--widgets '[
    {
      "ViewProperties": {
        "Height": "2",
        "Width": "4",
        "Title": "TopErrors",
        "View": "Table"
      },
      "QueryStatement": "SELECT errorCode, COUNT(*) AS eventCount FROM eds WHERE eventTime > '?' AND eventTime < '?' AND (errorCode is not null) GROUP BY errorCode ORDER BY eventCount DESC LIMIT 100",
      "QueryParameters": ["$StartTime$", "$EndTime$"]
    },
    {
      "ViewProperties": {
        "Height": "2",
        "Width": "4",
        "Title": "MostActiveRegions",
        "View": "PieChart",
        "LabelColumn": "awsRegion",
        "ValueColumn": "eventCount",
        "FilterColumn": "awsRegion"
      },
      "QueryStatement": "SELECT awsRegion, COUNT(*) AS eventCount FROM eds where eventTime > '?' and eventTime < '?' GROUP BY awsRegion ORDER BY eventCount LIMIT 100",
      "QueryParameters": ["$StartTime$", "$EndTime$"]
    },
    {
      "ViewProperties": {
        "Height": "2",
        "Width": "4",
        "Title": "AccountActivity",
        "View": "LineChart",
        "YAxisColumn": "eventCount",
        "XAxisColumn": "eventDate",
        "FilterColumn": "readOnly"
      },
      "QueryStatement": "SELECT DATE_TRUNC('?', eventTime) AS eventDate, IF(readOnly, 'read', 'write') AS readOnly, COUNT(*) as eventCount FROM eds WHERE eventTime > '?' AND eventTime < '?' GROUP BY DATE_TRUNC('?', eventTime), readOnly ORDER BY DATE_TRUNC('?', eventTime), readOnly",
      "QueryParameters": ["$Period$", "$StartTime$", "$EndTime$", "$Period$", "$Period$"]
    },
    {
      "ViewProperties": {
        "Height": "2",
        "Width": "4",
        "Title": "TopServices",
        "View": "BarChart",
        "LabelColumn": "service",
        "ValueColumn": "eventCount",
        "FilterColumn": "service",
        "Orientation": "Horizontal"
      },
      "QueryStatement": "SELECT REPLACE(eventSource, '.amazonaws.com') AS service, COUNT(*) AS eventCount FROM eds WHERE eventTime > '?' AND eventTime < '?' GROUP BY eventSource ORDER BY eventCount DESC LIMIT 100",
      "QueryParameters": ["$StartTime$", "$EndTime$"]
    }
  ]'

Create a separate file with the resource policy needed for each event data store that is included in a widget's QueryStatement. Name the file policy.json, with the following example policy statement:

Replace 123456789012 with your account ID, arn:aws:cloudtrail:us-east-1:123456789012:dashboard/exampleDashboard with the ARN of the dashboard.

For more information about resource-based policies for dashboards, see Example: Allow CloudTrail to run queries to refresh a dashboard.

Run the put-resource-policy command to attach the policy. You can also update an event data store's resource-based policy on the CloudTrail console.

The following example attaches a resource-based policy to an event data store.

aws cloudtrail put-resource-policy \
--resource-arn eds-arn \
--resource-policy file://policy.json

Run the put-resource-policy command to attach a resource-based policy to the dashboard. For an example policy, see Resource-based policy example for a dashboard.

The following example attaches a resource-based policy to a dashboard. Replace account-id with your account ID and dashboard-arn with the ARN of the dashboard.

aws cloudtrail put-resource-policy \
--resource-arn dashboard-arn \
--resource-policy '{"Version": "2012-10-17",		 	 	  "Statement": [{"Sid": "DashboardPolicy", "Effect": "Allow", "Principal": { "Service": "cloudtrail.amazonaws.com" }, "Action": "cloudtrail:StartDashboardRefresh", "Condition": { "StringEquals": { "AWS:SourceArn": "dashboard-arn", "AWS:SourceAccount": "account-id"}}}]}'

Run the update-dashboard command to set and enable a refresh schedule by configuring the --refresh-schedule parameter.

The --refresh-schedule consists of the following optional parameters:

The following example sets a refresh schedule for every six hours and enables the schedule.

aws cloudtrail update-dashboard --dashboard-id AccountActivityDashboard \
--refresh-schedule '{"Frequency": {"Unit": "HOURS", "Value": 6}, "Status": "ENABLED"}'

Run the create-dashboard command to create the Highlights dashboard. To create this dashboard, the --name must be AWSCloudTrail-Highlights.

aws cloudtrail create-dashboard --name AWSCloudTrail-Highlights

For each event data store in your account, run the put-resource-policy command to attach a resource-based policy to the event data store. You can also update an event data store's resource-based policy on the CloudTrail console. For an example policy, see Example: Allow CloudTrail to run queries to refresh a dashboard.

The following example attaches a resource-based policy to an event data store. Replace account-id with your account ID, eds-arn with the ARN of the event data store, and dashboard-arn with the ARN of the dashboard.

aws cloudtrail put-resource-policy \
--resource-arn eds-arn \
--resource-policy '{"Version": "2012-10-17",		 	 	  "Statement": [{"Sid": "EDSPolicy", "Effect": "Allow", "Principal": { "Service": "cloudtrail.amazonaws.com" }, "Action": "cloudtrail:StartQuery", "Condition": { "StringEquals": { "AWS:SourceArn": "dashboard-arn", "AWS:SourceAccount": "account-id"}}} ]}'

Run the put-resource-policy command to attach a resource-based policy to the dashboard. For an example policy, see Resource-based policy example for a dashboard.

The following example attaches a resource-based policy to a dashboard. Replace account-id with your account ID and dashboard-arn with the ARN of the dashboard.

aws cloudtrail put-resource-policy \
--resource-arn dashboard-arn \
--resource-policy '{"Version": "2012-10-17",		 	 	  "Statement": [{"Sid": "DashboardPolicy", "Effect": "Allow", "Principal": { "Service": "cloudtrail.amazonaws.com" }, "Action": "cloudtrail:StartDashboardRefresh", "Condition": { "StringEquals": { "AWS:SourceArn": "dashboard-arn", "AWS:SourceAccount": "account-id"}}}]}'

Run the update-dashboard command to set and enable a refresh schedule by configuring the --refresh-schedule parameter. For the Highlights dashboard, the only valid UNIT is HOURS and the only valid Value is 6.

aws cloudtrail update-dashboard --dashboard-id AWSCloudTrail-Highlights \
--refresh-schedule '{"Frequency": {"Unit": "HOURS", "Value": 6}, "Status": "ENABLED"}'