Skip to main content

applications

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

Overview

Nameapplications
TypeResource
Idazure.security.applications

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstring (arm-id)Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
namestringThe name of the resource
propertiesobjectProperties of a security application
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
getselectsubscriptionId, applicationIdapi-versionGet a specific application for the requested scope by applicationId
listselectsubscriptionIdapi-versionGet a list of all relevant applications over a subscription level scope
create_or_updateinsertsubscriptionId, applicationIdapi-versionCreates or update a security application on the given subscription.
deletedeletesubscriptionId, applicationIdapi-versionDelete an Application over a given scope

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
applicationIdstringThe security Application key - unique key for the standard application
subscriptionIdstringAzure subscription ID
api-versionstringAPI version for the operation

SELECT examples

Get a specific application for the requested scope by applicationId

SELECT
id,
name,
properties,
systemData,
type
FROM azure.security.applications
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND applicationId = '{{ applicationId }}' -- required
AND api-version = '{{ api-version }}'
;

INSERT examples

Creates or update a security application on the given subscription.

INSERT INTO azure.security.applications (
data__properties,
subscriptionId,
applicationId,
api-version
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ applicationId }}',
'{{ api-version }}'
RETURNING
id,
name,
properties,
systemData,
type
;

DELETE examples

Delete an Application over a given scope

DELETE FROM azure.security.applications
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND applicationId = '{{ applicationId }}' --required
AND api-version = '{{ api-version }}'
;