configurations

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

Overview

Name	configurations
Type	Resource
Id	azure.advisor.configurations

Fields

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
name	string	The name of the resource
properties	object	Configuration data properties
systemData	object	Metadata pertaining to creation and last modification of the resource.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

Name	Accessible by	Required Params	Description
list_by_resource_group	SELECT	resourceGroup, subscriptionId
list_by_subscription	SELECT	subscriptionId	Retrieve Azure Advisor configurations and also retrieve configurations of contained resource groups.
create_in_resource_group	INSERT	configurationName, resourceGroup, subscriptionId
create_in_subscription	INSERT	configurationName, subscriptionId	Create/Overwrite Azure Advisor configuration and also delete all configurations of contained resource groups.

SELECT examples

Retrieve Azure Advisor configurations and also retrieve configurations of contained resource groups.

SELECT
id,
name,
properties,
systemData,
type
FROM azure.advisor.configurations
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.advisor.configurations (
configurationName,
subscriptionId,
properties
)
SELECT 
'{{ configurationName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - 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: exclude
          value: boolean
        - name: lowCpuThreshold
          value: string
        - name: duration
          value: string
        - name: digests
          value:
            - - name: name
                value: string
              - name: actionGroupResourceId
                value: string
              - name: frequency
                value: integer
              - name: categories
                value:
                  - string
              - name: language
                value: string
              - name: state
                value: string