reports

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

Overview

Name	reports
Type	Resource
Id	azure_extras.app_compliance_automation.reports

Fields

vw_reports

Name	Datatype	Description
cert_records	text	field from the properties object
compliance_status	text	field from the properties object
errors	text	field from the properties object
last_trigger_time	text	field from the properties object
next_trigger_time	text	field from the properties object
offer_guid	text	field from the properties object
provisioning_state	text	field from the properties object
reportName	text	field from the properties object
resources	text	field from the properties object
status	text	field from the properties object
storage_info	text	field from the properties object
subscriptions	text	field from the properties object
tenant_id	text	field from the properties object
time_zone	text	field from the properties object
trigger_time	text	field from the properties object

reports

Name	Datatype	Description
properties	object	Create Report's properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	reportName	Get the AppComplianceAutomation report and its properties.
list	SELECT		Get the AppComplianceAutomation report list for the tenant.
create_or_update	INSERT	reportName, data__properties	Create a new AppComplianceAutomation report or update an exiting AppComplianceAutomation report.
delete	DELETE	reportName	Delete an AppComplianceAutomation report.
update	UPDATE	reportName	Update an exiting AppComplianceAutomation report.
fix	EXEC	reportName	Fix the AppComplianceAutomation report error. e.g: App Compliance Automation Tool service unregistered, automation removed.
nested_resource_check_name_availability	EXEC	reportName	Checks the report's nested resource name availability, e.g: Webhooks, Evidences, Snapshots.
sync_cert_record	EXEC	reportName, data__certRecord	Synchronize attestation record from app compliance.
verify	EXEC	reportName	Verify the AppComplianceAutomation report health status.

SELECT examples

Get the AppComplianceAutomation report list for the tenant.

vw_reports

SELECT
cert_records,
compliance_status,
errors,
last_trigger_time,
next_trigger_time,
offer_guid,
provisioning_state,
reportName,
resources,
status,
storage_info,
subscriptions,
tenant_id,
time_zone,
trigger_time
FROM azure_extras.app_compliance_automation.vw_reports
;

reports

SELECT
properties
FROM azure_extras.app_compliance_automation.reports
;

INSERT example

Use the following StackQL query and manifest file to create a new reports resource.

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: triggerTime
          value: string
        - name: timeZone
          value: string
        - name: resources
          value:
            - - name: resourceId
                value: string
              - name: resourceType
                value: string
              - name: resourceKind
                value: string
              - name: resourceOrigin
                value: []
              - name: accountId
                value: string
        - name: status
          value: []
        - name: errors
          value:
            - string
        - name: tenantId
          value: string
        - name: offerGuid
          value: string
        - name: nextTriggerTime
          value: string
        - name: lastTriggerTime
          value: string
        - name: subscriptions
          value:
            - string
        - name: complianceStatus
          value:
            - name: m365
              value:
                - name: passedCount
                  value: integer
                - name: failedCount
                  value: integer
                - name: manualCount
                  value: integer
                - name: notApplicableCount
                  value: integer
                - name: pendingCount
                  value: integer
        - name: storageInfo
          value:
            - name: subscriptionId
              value: string
            - name: resourceGroup
              value: string
            - name: accountName
              value: string
            - name: location
              value: string
        - name: certRecords
          value:
            - - name: offerGuid
                value: string
              - name: certificationStatus
                value: string
              - name: ingestionStatus
                value: string
              - name: controls
                value:
                  - - name: controlId
                      value: string
                    - name: controlStatus
                      value: string
        - name: provisioningState
          value: []

UPDATE example

Updates a reports resource.

/*+ update */
UPDATE azure_extras.app_compliance_automation.reports
SET 
properties = '{{ properties }}'
WHERE 
reportName = '{{ reportName }}';

DELETE example

Deletes the specified reports resource.

/*+ delete */
DELETE FROM azure_extras.app_compliance_automation.reports
WHERE reportName = '{{ reportName }}';