Skip to main content

azure_dev_ops_projects

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

Overview

Nameazure_dev_ops_projects
TypeResource
Idazure.security.azure_dev_ops_projects

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
actionableRemediationobjectConfiguration payload for PR Annotations.
onboardingStatestringDetails about resource onboarding status across all connectors. OnboardedByOtherConnector - this resource has already been onboarded to another connector. This is only applicable to top-level resources. Onboarded - this resource has already been onboarded by the specified connector. NotOnboarded - this resource has not been onboarded to any connector. NotApplicable - the onboarding state is not applicable to the current endpoint. Known values are: "NotApplicable", "OnboardedByOtherConnector", "Onboarded", and "NotOnboarded". (NotApplicable, OnboardedByOtherConnector, Onboarded, NotOnboarded)
parentOrgNamestringGets or sets parent Azure DevOps Organization name.
projectIdstringGets or sets Azure DevOps Project id.
provisioningStatestringThe provisioning state of the resource. Pending - Provisioning pending. Failed - Provisioning failed. Succeeded - Successful provisioning. Canceled - Provisioning canceled. PendingDeletion - Deletion pending. DeletionSuccess - Deletion successful. DeletionFailure - Deletion failure. Known values are: "Succeeded", "Failed", "Canceled", "Pending", "PendingDeletion", "DeletionSuccess", and "DeletionFailure". (Succeeded, Failed, Canceled, Pending, PendingDeletion, DeletionSuccess, DeletionFailure)
provisioningStatusMessagestringGets the resource status message.
provisioningStatusUpdateTimeUtcstring (date-time)Gets the time when resource was last checked.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, security_connector_name, org_name, project_name, subscription_idReturns a monitored Azure DevOps project resource. Returns a monitored Azure DevOps project resource.
listselectresource_group_name, security_connector_name, org_name, subscription_idReturns a list of Azure DevOps projects onboarded to the connector. Returns a list of Azure DevOps projects onboarded to the connector.
create_or_updateinsertresource_group_name, security_connector_name, org_name, project_name, subscription_idCreates or updates a monitored Azure DevOps project resource. Creates or updates a monitored Azure DevOps project resource.
updateupdateresource_group_name, security_connector_name, org_name, project_name, subscription_idUpdates a monitored Azure DevOps project resource. Updates a monitored Azure DevOps project resource.
create_or_updatereplaceresource_group_name, security_connector_name, org_name, project_name, subscription_idCreates or updates a monitored Azure DevOps project resource. Creates or updates a monitored Azure DevOps project resource.

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
org_namestringRequired.
project_namestringRequired.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
security_connector_namestringThe security connector name. Required.
subscription_idstring

SELECT examples

Returns a monitored Azure DevOps project resource. Returns a monitored Azure DevOps project resource.

SELECT
id,
name,
actionableRemediation,
onboardingState,
parentOrgName,
projectId,
provisioningState,
provisioningStatusMessage,
provisioningStatusUpdateTimeUtc,
systemData,
type
FROM azure.security.azure_dev_ops_projects
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND security_connector_name = '{{ security_connector_name }}' -- required
AND org_name = '{{ org_name }}' -- required
AND project_name = '{{ project_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates or updates a monitored Azure DevOps project resource. Creates or updates a monitored Azure DevOps project resource.

INSERT INTO azure.security.azure_dev_ops_projects (
properties,
resource_group_name,
security_connector_name,
org_name,
project_name,
subscription_id
)
SELECT
'{{ properties }}',
'{{ resource_group_name }}',
'{{ security_connector_name }}',
'{{ org_name }}',
'{{ project_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

UPDATE examples

Updates a monitored Azure DevOps project resource. Updates a monitored Azure DevOps project resource.

UPDATE azure.security.azure_dev_ops_projects
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND security_connector_name = '{{ security_connector_name }}' --required
AND org_name = '{{ org_name }}' --required
AND project_name = '{{ project_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

REPLACE examples

Creates or updates a monitored Azure DevOps project resource. Creates or updates a monitored Azure DevOps project resource.

REPLACE azure.security.azure_dev_ops_projects
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND security_connector_name = '{{ security_connector_name }}' --required
AND org_name = '{{ org_name }}' --required
AND project_name = '{{ project_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;