Skip to main content

report_jobs

Creates, updates, deletes, gets or lists a report_jobs resource.

Overview

Namereport_jobs
TypeResource
Idaws.backup.report_jobs

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
completion_timestring (date-time)The date and time that a report job is completed, in Unix format and Coordinated Universal Time (UTC). The value of CompletionTime is accurate to milliseconds. For example, the value 1516925490.087 represents Friday, January 26, 2018 12:11:30.087 AM.
creation_timestring (date-time)The date and time that a report job is created, in Unix format and Coordinated Universal Time (UTC). The value of CreationTime is accurate to milliseconds. For example, the value 1516925490.087 represents Friday, January 26, 2018 12:11:30.087 AM.
report_destinationobjectThe S3 bucket name and S3 keys for the destination where the report job publishes the report.
report_job_idstringThe identifier for a report job. A unique, randomly generated, Unicode, UTF-8 encoded string that is at most 1,024 bytes long. Report job IDs cannot be edited.
report_plan_arnstringAn Amazon Resource Name (ARN) that uniquely identifies a resource. The format of the ARN depends on the resource type.
report_templatestringIdentifies the report template for the report. Reports are built using a report template. The report templates are: RESOURCE_COMPLIANCE_REPORT | CONTROL_COMPLIANCE_REPORT | BACKUP_JOB_REPORT | COPY_JOB_REPORT | RESTORE_JOB_REPORT
statusstringThe status of a report job. The statuses are: CREATED | RUNNING | COMPLETED | FAILED COMPLETED means that the report is available for your review at your designated destination. If the status is FAILED, review the StatusMessage for the reason.
status_messagestringA message explaining the status of the report job.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
describe_report_jobselectreport_job_id, regionReturns the details associated with creating a report as specified by its ReportJobId.
list_report_jobsselectregionReportPlanName, CreationBefore, CreationAfter, Status, MaxResults, NextTokenReturns details about your report jobs.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
regionstringAWS region (default: us-east-1)
report_job_idstringThe identifier of the report job. A unique, randomly generated, Unicode, UTF-8 encoded string that is at most 1,024 bytes long. The report job ID cannot be edited.
CreationAfterstring (date-time)Returns only report jobs that were created after the date and time specified in Unix format and Coordinated Universal Time (UTC). For example, the value 1516925490 represents Friday, January 26, 2018 12:11:30 AM.
CreationBeforestring (date-time)Returns only report jobs that were created before the date and time specified in Unix format and Coordinated Universal Time (UTC). For example, the value 1516925490 represents Friday, January 26, 2018 12:11:30 AM.
MaxResultsintegerThe number of desired results from 1 to 1000. Optional. If unspecified, the query will return 1 MB of data.
NextTokenstringAn identifier that was returned from the previous call to this operation, which can be used to return the next set of items in the list.
ReportPlanNamestringReturns only report jobs with the specified report plan name.
StatusstringReturns only report jobs that are in the specified status. The statuses are: CREATED | RUNNING | COMPLETED | FAILED | COMPLETED_WITH_ISSUES Please note that only scanning jobs finish with state completed with issues. For backup jobs this is a console interpretation of a job that finishes in completed state and has a status message.

SELECT examples

Returns the details associated with creating a report as specified by its ReportJobId.

SELECT
completion_time,
creation_time,
report_destination,
report_job_id,
report_plan_arn,
report_template,
status,
status_message
FROM aws.backup.report_jobs
WHERE report_job_id = '{{ report_job_id }}' -- required
AND region = '{{ region }}' -- required
;