software_update_configurations

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

Overview

Name	software_update_configurations
Type	Resource
Id	azure.automation.software_update_configurations

Fields

vw_software_update_configurations

Name	Datatype	Description
id	text	Resource Id.
name	text	Resource name.
automationAccountName	text	field from the properties object
created_by	text	field from the properties object
creation_time	text	field from the properties object
error	text	field from the properties object
last_modified_by	text	field from the properties object
last_modified_time	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
schedule_info	text	field from the properties object
softwareUpdateConfigurationName	text	field from the properties object
subscriptionId	text	field from the properties object
tasks	text	field from the properties object
type	string	Resource type
update_configuration	text	field from the properties object

software_update_configurations

Name	Datatype	Description
id	string	Resource Id.
name	string	Resource name.
properties	object	Software update configuration properties.
type	string	Resource type

Methods

Name	Accessible by	Required Params	Description
get_by_name	SELECT	automationAccountName, resourceGroupName, softwareUpdateConfigurationName, subscriptionId	Get a single software update configuration by name.
list	SELECT	automationAccountName, resourceGroupName, subscriptionId	Get all software update configurations for the account.
create	INSERT	automationAccountName, resourceGroupName, softwareUpdateConfigurationName, subscriptionId, data__properties	Create a new software update configuration with the name given in the URI.
delete	DELETE	automationAccountName, resourceGroupName, softwareUpdateConfigurationName, subscriptionId	delete a specific software update configuration.

SELECT examples

Get all software update configurations for the account.

vw_software_update_configurations

SELECT
id,
name,
automationAccountName,
created_by,
creation_time,
error,
last_modified_by,
last_modified_time,
provisioning_state,
resourceGroupName,
schedule_info,
softwareUpdateConfigurationName,
subscriptionId,
tasks,
type,
update_configuration
FROM azure.automation.vw_software_update_configurations
WHERE automationAccountName = '{{ automationAccountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

software_update_configurations

SELECT
id,
name,
properties,
type
FROM azure.automation.software_update_configurations
WHERE automationAccountName = '{{ automationAccountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.automation.software_update_configurations (
automationAccountName,
resourceGroupName,
softwareUpdateConfigurationName,
subscriptionId,
data__properties,
properties
)
SELECT 
'{{ automationAccountName }}',
'{{ resourceGroupName }}',
'{{ softwareUpdateConfigurationName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: name
      value: string
    - name: id
      value: string
    - name: type
      value: string
    - name: properties
      value:
        - name: updateConfiguration
          value:
            - name: operatingSystem
              value: []
            - name: windows
              value:
                - name: includedUpdateClassifications
                  value: string
                - name: excludedKbNumbers
                  value:
                    - string
                - name: includedKbNumbers
                  value:
                    - string
                - name: rebootSetting
                  value: string
            - name: linux
              value:
                - name: includedPackageClassifications
                  value: string
                - name: excludedPackageNameMasks
                  value:
                    - string
                - name: includedPackageNameMasks
                  value:
                    - string
                - name: rebootSetting
                  value: string
            - name: duration
              value: string
            - name: azureVirtualMachines
              value:
                - string
            - name: nonAzureComputerNames
              value:
                - string
            - name: targets
              value:
                - name: azureQueries
                  value:
                    - - name: scope
                        value:
                          - string
                      - name: locations
                        value:
                          - string
                      - name: tagSettings
                        value:
                          - name: tags
                            value: object
                          - name: filterOperator
                            value: string
                - name: nonAzureQueries
                  value:
                    - - name: functionAlias
                        value: string
                      - name: workspaceId
                        value: string
        - name: scheduleInfo
          value:
            - name: startTime
              value: string
            - name: startTimeOffsetMinutes
              value: number
            - name: expiryTime
              value: string
            - name: expiryTimeOffsetMinutes
              value: number
            - name: isEnabled
              value: boolean
            - name: nextRun
              value: string
            - name: nextRunOffsetMinutes
              value: number
            - name: interval
              value: integer
            - name: frequency
              value: []
            - name: timeZone
              value: string
            - name: advancedSchedule
              value:
                - name: weekDays
                  value:
                    - string
                - name: monthDays
                  value:
                    - integer
                - name: monthlyOccurrences
                  value:
                    - - name: occurrence
                        value: integer
                      - name: day
                        value: string
            - name: creationTime
              value: string
            - name: lastModifiedTime
              value: string
            - name: description
              value: string
        - name: provisioningState
          value: string
        - name: error
          value:
            - name: error
              value:
                - name: code
                  value: string
                - name: message
                  value: string
                - name: target
                  value: string
                - name: details
                  value:
                    - - name: code
                        value: string
                      - name: message
                        value: string
                      - name: target
                        value: string
                      - name: details
                        value:
                          - - name: code
                              value: string
                            - name: message
                              value: string
                            - name: target
                              value: string
                            - name: details
                              value:
                                - - name: code
                                    value: string
                                  - name: message
                                    value: string
                                  - name: target
                                    value: string
                                  - name: details
                                    value:
                                      - - name: code
                                          value: string
                                        - name: message
                                          value: string
                                        - name: target
                                          value: string
                                        - name: details
                                          value:
                                            - - name: code
                                                value: string
                                              - name: message
                                                value: string
                                              - name: target
                                                value: string
                                              - name: details
                                                value:
                                                  - - name: code
                                                      value: string
                                                    - name: message
                                                      value: string
                                                    - name: target
                                                      value: string
                                                    - name: details
                                                      value:
                                                        - - name: code
                                                            value: string
                                                          - name: message
                                                            value: string
                                                          - name: target
                                                            value: string
                                                          - name: details
                                                            value:
                                                              - []
                                                          - name: additionalInfo
                                                            value:
                                                              - []
                                                    - name: additionalInfo
                                                      value:
                                                        - - name: type
                                                            value: string
                                                          - name: info
                                                            value: object
                                              - name: additionalInfo
                                                value:
                                                  - - name: type
                                                      value: string
                                                    - name: info
                                                      value: object
                                        - name: additionalInfo
                                          value:
                                            - - name: type
                                                value: string
                                              - name: info
                                                value: object
                                  - name: additionalInfo
                                    value:
                                      - - name: type
                                          value: string
                                        - name: info
                                          value: object
                            - name: additionalInfo
                              value:
                                - - name: type
                                    value: string
                                  - name: info
                                    value: object
                      - name: additionalInfo
                        value:
                          - - name: type
                              value: string
                            - name: info
                              value: object
                - name: additionalInfo
                  value:
                    - - name: type
                        value: string
                      - name: info
                        value: object
        - name: creationTime
          value: string
        - name: createdBy
          value: string
        - name: lastModifiedTime
          value: string
        - name: lastModifiedBy
          value: string
        - name: tasks
          value:
            - name: preTask
              value:
                - name: parameters
                  value: object
                - name: source
                  value: string

DELETE example

Deletes the specified software_update_configurations resource.

/*+ delete */
DELETE FROM azure.automation.software_update_configurations
WHERE automationAccountName = '{{ automationAccountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND softwareUpdateConfigurationName = '{{ softwareUpdateConfigurationName }}'
AND subscriptionId = '{{ subscriptionId }}';