azure_dev_ops_projects

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

Overview

Name	azure_dev_ops_projects
Type	Resource
Id	azure.security.azure_dev_ops_projects

Fields

vw_azure_dev_ops_projects

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
projectName	text	field from the properties object
project_id	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
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

azure_dev_ops_projects

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

Methods

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

SELECT examples

vw_azure_dev_ops_projects

SELECT
actionable_remediation,
onboarding_state,
orgName,
parent_org_name,
projectName,
project_id,
provisioning_state,
provisioning_status_message,
provisioning_status_update_time_utc,
resourceGroupName,
securityConnectorName,
subscriptionId,
system_data
FROM azure.security.vw_azure_dev_ops_projects
WHERE orgName = '{{ orgName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND securityConnectorName = '{{ securityConnectorName }}'
AND subscriptionId = '{{ subscriptionId }}';

azure_dev_ops_projects

SELECT
properties,
systemData
FROM azure.security.azure_dev_ops_projects
WHERE orgName = '{{ orgName }}'
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_projects resource.

All Properties

/*+ create */
INSERT INTO azure.security.azure_dev_ops_projects (
orgName,
projectName,
resourceGroupName,
securityConnectorName,
subscriptionId,
systemData,
properties
)
SELECT 
'{{ orgName }}',
'{{ projectName }}',
'{{ 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: projectId
          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_projects resource.

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