azure_dev_ops_repos

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

Overview

Name	azure_dev_ops_repos
Type	Resource
Id	azure.security.azure_dev_ops_repos

Fields

vw_azure_dev_ops_repos

Name	Datatype	Description
actionable_remediation	text	field from the properties object
onboarding_state	text	field from the properties object
orgName	text	field from the properties object
parent_org_name	text	field from the properties object
parent_project_name	text	field from the properties object
projectName	text	field from the properties object
provisioning_state	text	field from the properties object
provisioning_status_message	text	field from the properties object
provisioning_status_update_time_utc	text	field from the properties object
repoName	text	field from the properties object
repo_id	text	field from the properties object
repo_url	text	field from the properties object
resourceGroupName	text	field from the properties object
securityConnectorName	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
visibility	text	field from the properties object

azure_dev_ops_repos

Name	Datatype	Description
properties	object	Azure DevOps Repository properties.
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	orgName, projectName, repoName, resourceGroupName, securityConnectorName, subscriptionId
list	SELECT	orgName, projectName, resourceGroupName, securityConnectorName, subscriptionId
create_or_update	INSERT	orgName, projectName, repoName, resourceGroupName, securityConnectorName, subscriptionId
update	UPDATE	orgName, projectName, repoName, resourceGroupName, securityConnectorName, subscriptionId

SELECT examples

vw_azure_dev_ops_repos

SELECT
actionable_remediation,
onboarding_state,
orgName,
parent_org_name,
parent_project_name,
projectName,
provisioning_state,
provisioning_status_message,
provisioning_status_update_time_utc,
repoName,
repo_id,
repo_url,
resourceGroupName,
securityConnectorName,
subscriptionId,
system_data,
visibility
FROM azure.security.vw_azure_dev_ops_repos
WHERE orgName = '{{ orgName }}'
AND projectName = '{{ projectName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND securityConnectorName = '{{ securityConnectorName }}'
AND subscriptionId = '{{ subscriptionId }}';

azure_dev_ops_repos

SELECT
properties,
systemData
FROM azure.security.azure_dev_ops_repos
WHERE orgName = '{{ orgName }}'
AND projectName = '{{ projectName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND securityConnectorName = '{{ securityConnectorName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.security.azure_dev_ops_repos (
orgName,
projectName,
repoName,
resourceGroupName,
securityConnectorName,
subscriptionId,
systemData,
properties
)
SELECT 
'{{ orgName }}',
'{{ projectName }}',
'{{ repoName }}',
'{{ resourceGroupName }}',
'{{ securityConnectorName }}',
'{{ subscriptionId }}',
'{{ systemData }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: properties
      value:
        - name: provisioningStatusMessage
          value: string
        - name: provisioningStatusUpdateTimeUtc
          value: string
        - name: provisioningState
          value: []
        - name: parentOrgName
          value: string
        - name: parentProjectName
          value: string
        - name: repoId
          value: string
        - name: repoUrl
          value: string
        - name: visibility
          value: string
        - name: onboardingState
          value: []
        - name: actionableRemediation
          value:
            - name: state
              value: []
            - name: categoryConfigurations
              value:
                - - name: minimumSeverityLevel
                    value: string
                  - name: category
                    value: []
            - name: branchConfiguration
              value:
                - name: branchNames
                  value:
                    - string
                - name: annotateDefaultBranch
                  value: []
            - name: inheritFromParentState
              value: []

UPDATE example

Updates a azure_dev_ops_repos resource.

/*+ update */
UPDATE azure.security.azure_dev_ops_repos
SET 
systemData = '{{ systemData }}',
properties = '{{ properties }}'
WHERE 
orgName = '{{ orgName }}'
AND projectName = '{{ projectName }}'
AND repoName = '{{ repoName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND securityConnectorName = '{{ securityConnectorName }}'
AND subscriptionId = '{{ subscriptionId }}';