Skip to main content

reports

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

Overview

Namereports
TypeResource
Idazure_extras.app_compliance_automation.reports

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
propertiesobjectReport property.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectreportNameGet the AppComplianceAutomation report and its properties.
listselect$skipToken, $top, $select, $filter, $orderby, offerGuid, reportCreatorTenantIdGet the AppComplianceAutomation report list for the tenant.
create_or_updateinsertreportName, data__propertiesCreate a new AppComplianceAutomation report or update an exiting AppComplianceAutomation report.
updateupdatereportNameUpdate an exiting AppComplianceAutomation report.
deletedeletereportNameDelete an AppComplianceAutomation report.
nested_resource_check_name_availabilityexecreportNameChecks the report's nested resource name availability, e.g: Webhooks, Evidences, Snapshots.
fixexecreportNameFix the AppComplianceAutomation report error. e.g: App Compliance Automation Tool service unregistered, automation removed.
sync_cert_recordexecreportName, certRecordSynchronize attestation record from app compliance.
verifyexecreportNameVerify the AppComplianceAutomation report health status.

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
reportNamestringReport Name.
$filterstringThe filter to apply on the operation.
$orderbystringOData order by query option.
$selectstringOData Select statement. Limits the properties on each entry to just those requested, e.g. ?$select=reportName,id.
$skipTokenstringSkip over when retrieving results.
$topinteger (int32)Number of elements to return when retrieving results.
offerGuidstringThe offerGuid which mapping to the reports.
reportCreatorTenantIdstringThe tenant id of the report creator.

SELECT examples

Get the AppComplianceAutomation report and its properties.

SELECT
properties
FROM azure_extras.app_compliance_automation.reports
WHERE reportName = '{{ reportName }}' -- required
;

INSERT examples

Create a new AppComplianceAutomation report or update an exiting AppComplianceAutomation report.

INSERT INTO azure_extras.app_compliance_automation.reports (
data__properties,
reportName
)
SELECT
'{{ properties }}' /* required */,
'{{ reportName }}'
RETURNING
properties
;

UPDATE examples

Update an exiting AppComplianceAutomation report.

UPDATE azure_extras.app_compliance_automation.reports
SET
data__properties = '{{ properties }}'
WHERE
reportName = '{{ reportName }}' --required
RETURNING
properties;

DELETE examples

Delete an AppComplianceAutomation report.

DELETE FROM azure_extras.app_compliance_automation.reports
WHERE reportName = '{{ reportName }}' --required
;

Lifecycle Methods

Checks the report's nested resource name availability, e.g: Webhooks, Evidences, Snapshots.

EXEC azure_extras.app_compliance_automation.reports.nested_resource_check_name_availability 
@reportName='{{ reportName }}' --required
@@json=
'{
"name": "{{ name }}",
"type": "{{ type }}"
}'
;