Skip to main content

azure_dev_ops_orgs

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

Overview

Nameazure_dev_ops_orgs
TypeResource
Idazure.security.azure_dev_ops_orgs

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)
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, subscription_idReturns a monitored Azure DevOps organization resource. Returns a monitored Azure DevOps organization resource.
listselectresource_group_name, security_connector_name, subscription_idReturns a list of Azure DevOps organizations onboarded to the connector. Returns a list of Azure DevOps organizations onboarded to the connector.
create_or_updateinsertresource_group_name, security_connector_name, org_name, subscription_idCreates or updates monitored Azure DevOps organization details. Creates or updates monitored Azure DevOps organization details.
updateupdateresource_group_name, security_connector_name, org_name, subscription_idUpdates monitored Azure DevOps organization details. Updates monitored Azure DevOps organization details.
create_or_updatereplaceresource_group_name, security_connector_name, org_name, subscription_idCreates or updates monitored Azure DevOps organization details. Creates or updates monitored Azure DevOps organization details.
list_availableexecresource_group_name, security_connector_name, subscription_idReturns a list of all Azure DevOps organizations accessible by the user token consumed by the connector. Returns a list of all Azure DevOps organizations accessible by the user token consumed by the connector.

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.
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 organization resource. Returns a monitored Azure DevOps organization resource.

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

INSERT examples

Creates or updates monitored Azure DevOps organization details. Creates or updates monitored Azure DevOps organization details.

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

UPDATE examples

Updates monitored Azure DevOps organization details. Updates monitored Azure DevOps organization details.

UPDATE azure.security.azure_dev_ops_orgs
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 subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

REPLACE examples

Creates or updates monitored Azure DevOps organization details. Creates or updates monitored Azure DevOps organization details.

REPLACE azure.security.azure_dev_ops_orgs
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 subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

Lifecycle Methods

Returns a list of all Azure DevOps organizations accessible by the user token consumed by the connector. Returns a list of all Azure DevOps organizations accessible by the user token consumed by the connector.

EXEC azure.security.azure_dev_ops_orgs.list_available 
@resource_group_name='{{ resource_group_name }}' --required,
@security_connector_name='{{ security_connector_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
;