solutions

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

Overview

Name	solutions
Type	Resource
Id	azure_extras.help.solutions

Fields

vw_solutions

Name	Datatype	Description
content	text	field from the properties object
parameters	text	field from the properties object
provisioning_state	text	field from the properties object
replacement_maps	text	field from the properties object
scope	text	field from the properties object
sections	text	field from the properties object
solutionResourceName	text	field from the properties object
solution_id	text	field from the properties object
title	text	field from the properties object
trigger_criteria	text	field from the properties object

solutions

Name	Datatype	Description
properties	object	Solution result

Methods

Name	Accessible by	Required Params	Description
get	SELECT	scope, solutionResourceName	Get the solution using the applicable solutionResourceName while creating the solution.
create	INSERT	scope, solutionResourceName	Creates a solution for the specific Azure resource or subscription using the inputs ‘solutionId and requiredInputs’ from discovery solutions. Azure solutions comprise a comprehensive library of self-help resources that have been thoughtfully curated by Azure engineers to aid customers in resolving typical troubleshooting issues. These solutions encompass: (1.) Dynamic and context-aware diagnostics, guided troubleshooting wizards, and data visualizations. (2.) Rich instructional video tutorials and illustrative diagrams and images. (3.) Thoughtfully assembled textual troubleshooting instructions. All these components are seamlessly converged into unified solutions tailored to address a specific support problem area.
update	UPDATE	scope, solutionResourceName	Update the requiredInputs or additional information needed to execute the solution
warm_up	EXEC	scope, solutionResourceName	Warm up the solution resource by preloading asynchronous diagnostics results into cache

SELECT examples

Get the solution using the applicable solutionResourceName while creating the solution.

vw_solutions

SELECT
content,
parameters,
provisioning_state,
replacement_maps,
scope,
sections,
solutionResourceName,
solution_id,
title,
trigger_criteria
FROM azure_extras.help.vw_solutions
WHERE scope = '{{ scope }}'
AND solutionResourceName = '{{ solutionResourceName }}';

solutions

SELECT
properties
FROM azure_extras.help.solutions
WHERE scope = '{{ scope }}'
AND solutionResourceName = '{{ solutionResourceName }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.help.solutions (
scope,
solutionResourceName,
properties
)
SELECT 
'{{ scope }}',
'{{ solutionResourceName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: triggerCriteria
          value:
            - - name: name
                value: string
              - name: value
                value: string
        - name: parameters
          value: object
        - name: solutionId
          value: string
        - name: provisioningState
          value: string
        - name: title
          value: string
        - name: content
          value: string
        - name: replacementMaps
          value:
            - name: webResults
              value:
                - - name: replacementKey
                    value: string
                  - name: searchResults
                    value:
                      - - name: solutionId
                          value: string
                        - name: content
                          value: string
                        - name: title
                          value: string
                        - name: confidence
                          value: string
                        - name: source
                          value: string
                        - name: resultType
                          value: string
                        - name: rank
                          value: integer
                        - name: link
                          value: string
            - name: diagnostics
              value:
                - - name: solutionId
                    value: string
                  - name: status
                    value: []
                  - name: statusDetails
                    value: string
                  - name: replacementKey
                    value: string
                  - name: estimatedCompletionTime
                    value: string
                  - name: requiredParameters
                    value:
                      - string
                  - name: insights
                    value:
                      - - name: id
                          value: string
                        - name: title
                          value: string
                        - name: results
                          value: string
                        - name: importanceLevel
                          value: string
            - name: troubleshooters
              value:
                - - name: solutionId
                    value: string
                  - name: title
                    value: string
                  - name: summary
                    value: string
            - name: metricsBasedCharts
              value:
                - - name: name
                    value: string
                  - name: aggregationType
                    value: string
                  - name: timeSpanDuration
                    value: string
                  - name: title
                    value: string
                  - name: filterGroup
                    value:
                      - name: filter
                        value:
                          - - name: name
                              value: string
                            - name: values
                              value: string
                            - name: operator
                              value: string
                  - name: replacementKey
                    value: string
            - name: videos
              value:
                - - name: src
                    value: string
                  - name: title
                    value: string
                  - name: replacementKey
                    value: string
            - name: videoGroups
              value:
                - - name: videos
                    value:
                      - - name: src
                          value: string
                        - name: title
                          value: string
                  - name: replacementKey
                    value: string
        - name: sections
          value:
            - - name: title
                value: string
              - name: content
                value: string

UPDATE example

Updates a solutions resource.

/*+ update */
UPDATE azure_extras.help.solutions
SET 
properties = '{{ properties }}'
WHERE 
scope = '{{ scope }}'
AND solutionResourceName = '{{ solutionResourceName }}';