source_controls

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

Overview

Name	source_controls
Type	Resource
Id	azure.sentinel.source_controls

Fields

vw_source_controls

Name	Datatype	Description
id	text	field from the properties object
description	text	field from the properties object
content_types	text	field from the properties object
display_name	text	field from the properties object
etag	text	Etag of the azure resource
last_deployment_info	text	field from the properties object
pull_request	text	field from the properties object
repo_type	text	field from the properties object
repository	text	field from the properties object
repository_access	text	field from the properties object
repository_resource_info	text	field from the properties object
resourceGroupName	text	field from the properties object
service_principal	text	field from the properties object
sourceControlId	text	field from the properties object
subscriptionId	text	field from the properties object
version	text	field from the properties object
workspaceName	text	field from the properties object

source_controls

Name	Datatype	Description
etag	string	Etag of the azure resource
properties	object	Describes source control properties

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, sourceControlId, subscriptionId, workspaceName	Gets a source control byt its identifier.
list	SELECT	resourceGroupName, subscriptionId, workspaceName	Gets all source controls, without source control items.
create	INSERT	resourceGroupName, sourceControlId, subscriptionId, workspaceName, data__properties	Creates a source control.
delete	DELETE	resourceGroupName, sourceControlId, subscriptionId, workspaceName, data__properties	Delete a source control.

SELECT examples

Gets all source controls, without source control items.

vw_source_controls

SELECT
id,
description,
content_types,
display_name,
etag,
last_deployment_info,
pull_request,
repo_type,
repository,
repository_access,
repository_resource_info,
resourceGroupName,
service_principal,
sourceControlId,
subscriptionId,
version,
workspaceName
FROM azure.sentinel.vw_source_controls
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

source_controls

SELECT
etag,
properties
FROM azure.sentinel.source_controls
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.sentinel.source_controls (
resourceGroupName,
sourceControlId,
subscriptionId,
workspaceName,
data__properties,
etag,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ sourceControlId }}',
'{{ subscriptionId }}',
'{{ workspaceName }}',
'{{ data__properties }}',
'{{ etag }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: etag
      value: string
    - name: properties
      value:
        - name: id
          value: string
        - name: version
          value: []
        - name: displayName
          value: string
        - name: description
          value: string
        - name: repoType
          value: []
        - name: contentTypes
          value:
            - []
        - name: repository
          value:
            - name: url
              value: string
            - name: branch
              value: string
            - name: displayUrl
              value: string
            - name: deploymentLogsUrl
              value: string
        - name: servicePrincipal
          value:
            - name: id
              value: string
            - name: tenantId
              value: string
            - name: appId
              value: string
            - name: credentialsExpireOn
              value: string
        - name: repositoryAccess
          value:
            - name: kind
              value: []
            - name: code
              value: string
            - name: state
              value: string
            - name: clientId
              value: string
            - name: token
              value: string
            - name: installationId
              value: string
        - name: repositoryResourceInfo
          value:
            - name: webhook
              value:
                - name: webhookId
                  value: string
                - name: webhookUrl
                  value: string
                - name: webhookSecretUpdateTime
                  value: string
                - name: rotateWebhookSecret
                  value: boolean
            - name: gitHubResourceInfo
              value:
                - name: appInstallationId
                  value: string
            - name: azureDevOpsResourceInfo
              value:
                - name: pipelineId
                  value: string
                - name: serviceConnectionId
                  value: string
        - name: lastDeploymentInfo
          value:
            - name: deploymentFetchStatus
              value: []
            - name: deployment
              value:
                - name: deploymentId
                  value: string
                - name: deploymentState
                  value: []
                - name: deploymentResult
                  value: []
                - name: deploymentTime
                  value: string
                - name: deploymentLogsUrl
                  value: string
            - name: message
              value: string
        - name: pullRequest
          value:
            - name: url
              value: string
            - name: state
              value: []

DELETE example

Deletes the specified source_controls resource.

/*+ delete */
DELETE FROM azure.sentinel.source_controls
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sourceControlId = '{{ sourceControlId }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}'
AND data__properties = '{{ data__properties }}';