configurations

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

Overview

Name	configurations
Type	Resource
Id	azure.maintenance.configurations

Fields

vw_configurations

Name	Datatype	Description
id	text	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	text	The name of the resource
extension_properties	text	field from the properties object
install_patches	text	field from the properties object
location	text	Gets or sets location of the resource
maintenance_scope	text	field from the properties object
maintenance_window	text	field from the properties object
namespace	text	field from the properties object
resourceGroupName	text	field from the properties object
resourceName	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Gets or sets tags of the resource
type	text	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
visibility	text	field from the properties object

configurations

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	string	The name of the resource
location	string	Gets or sets location of the resource
properties	object	Properties for maintenance configuration
tags	object	Gets or sets tags 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
get	SELECT	resourceGroupName, resourceName, subscriptionId
list	SELECT	subscriptionId
create_or_update	INSERT	resourceGroupName, resourceName, subscriptionId
delete	DELETE	resourceGroupName, resourceName, subscriptionId
update	UPDATE	resourceGroupName, resourceName, subscriptionId

SELECT examples

vw_configurations

SELECT
id,
name,
extension_properties,
install_patches,
location,
maintenance_scope,
maintenance_window,
namespace,
resourceGroupName,
resourceName,
subscriptionId,
tags,
type,
visibility
FROM azure.maintenance.vw_configurations
WHERE subscriptionId = '{{ subscriptionId }}';

configurations

SELECT
id,
name,
location,
properties,
tags,
type
FROM azure.maintenance.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.maintenance.configurations (
resourceGroupName,
resourceName,
subscriptionId,
location,
tags,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ resourceName }}',
'{{ subscriptionId }}',
'{{ location }}',
'{{ tags }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: location
      value: string
    - name: tags
      value: object
    - name: properties
      value:
        - name: namespace
          value: string
        - name: extensionProperties
          value: object
        - name: maintenanceScope
          value: string
        - name: maintenanceWindow
          value:
            - name: startDateTime
              value: string
            - name: expirationDateTime
              value: string
            - name: duration
              value: string
            - name: timeZone
              value: string
            - name: recurEvery
              value: string
        - name: visibility
          value: string
        - name: installPatches
          value:
            - name: rebootSetting
              value: string
            - name: windowsParameters
              value:
                - name: kbNumbersToExclude
                  value:
                    - string
                - name: kbNumbersToInclude
                  value:
                    - string
                - name: classificationsToInclude
                  value:
                    - string
                - name: excludeKbsRequiringReboot
                  value: boolean
            - name: linuxParameters
              value:
                - name: packageNameMasksToExclude
                  value:
                    - string
                - name: packageNameMasksToInclude
                  value:
                    - string
                - name: classificationsToInclude
                  value:
                    - string

UPDATE example

Updates a configurations resource.

/*+ update */
UPDATE azure.maintenance.configurations
SET 
location = '{{ location }}',
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified configurations resource.

/*+ delete */
DELETE FROM azure.maintenance.configurations
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';