Link to resource definition: Microsoft.Sql/servers/databases/advisors
| Default Path | Alias |
|---|---|
properties.advisorStatus | Microsoft.Sql/servers/databases/advisors/advisorStatus |
properties.autoExecuteStatus | Microsoft.Sql/servers/databases/advisors/autoExecuteStatus |
properties.autoExecuteStatusInheritedFrom | Microsoft.Sql/servers/databases/advisors/autoExecuteStatusInheritedFrom |
properties.autoExecuteValue | Microsoft.Sql/servers/databases/advisors/autoExecuteValue |
properties.lastChecked | Microsoft.Sql/servers/databases/advisors/lastChecked |
properties.recommendationsStatus | Microsoft.Sql/servers/databases/advisors/recommendationsStatus |
properties.recommendedActions | Microsoft.Sql/servers/databases/advisors/recommendedActions |
properties.recommendedActions[*] | Microsoft.Sql/servers/databases/advisors/recommendedActions[*] |
properties.recommendedActions[*].id | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].id |
properties.recommendedActions[*].kind | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].kind |
properties.recommendedActions[*].location | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].location |
properties.recommendedActions[*].name | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].name |
properties.recommendedActions[*].properties.details | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].details |
properties.recommendedActions[*].properties.errorDetails | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].errorDetails |
properties.recommendedActions[*].properties.errorDetails.errorCode | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].errorDetails.errorCode |
properties.recommendedActions[*].properties.errorDetails.isRetryable | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].errorDetails.isRetryable |
properties.recommendedActions[*].properties.estimatedImpact | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].estimatedImpact |
properties.recommendedActions[*].properties.estimatedImpact[*] | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].estimatedImpact[*] |
properties.recommendedActions[*].properties.estimatedImpact[*].absoluteValue | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].estimatedImpact[*].absoluteValue |
properties.recommendedActions[*].properties.estimatedImpact[*].changeValueAbsolute | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].estimatedImpact[*].changeValueAbsolute |
properties.recommendedActions[*].properties.estimatedImpact[*].changeValueRelative | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].estimatedImpact[*].changeValueRelative |
properties.recommendedActions[*].properties.estimatedImpact[*].dimensionName | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].estimatedImpact[*].dimensionName |
properties.recommendedActions[*].properties.estimatedImpact[*].unit | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].estimatedImpact[*].unit |
properties.recommendedActions[*].properties.executeActionDuration | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].executeActionDuration |
properties.recommendedActions[*].properties.executeActionInitiatedBy | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].executeActionInitiatedBy |
properties.recommendedActions[*].properties.executeActionInitiatedTime | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].executeActionInitiatedTime |
properties.recommendedActions[*].properties.executeActionStartTime | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].executeActionStartTime |
properties.recommendedActions[*].properties.implementationDetails | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].implementationDetails |
properties.recommendedActions[*].properties.implementationDetails.method | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].implementationDetails.method |
properties.recommendedActions[*].properties.implementationDetails.script | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].implementationDetails.script |
properties.recommendedActions[*].properties.isArchivedAction | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].isArchivedAction |
properties.recommendedActions[*].properties.isExecutableAction | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].isExecutableAction |
properties.recommendedActions[*].properties.isRevertableAction | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].isRevertableAction |
properties.recommendedActions[*].properties.lastRefresh | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].lastRefresh |
properties.recommendedActions[*].properties.linkedObjects | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].linkedObjects |
properties.recommendedActions[*].properties.linkedObjects[*] | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].linkedObjects[*] |
properties.recommendedActions[*].properties.observedImpact | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].observedImpact |
properties.recommendedActions[*].properties.observedImpact[*] | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].observedImpact[*] |
properties.recommendedActions[*].properties.observedImpact[*].absoluteValue | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].observedImpact[*].absoluteValue |
properties.recommendedActions[*].properties.observedImpact[*].changeValueAbsolute | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].observedImpact[*].changeValueAbsolute |
properties.recommendedActions[*].properties.observedImpact[*].changeValueRelative | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].observedImpact[*].changeValueRelative |
properties.recommendedActions[*].properties.observedImpact[*].dimensionName | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].observedImpact[*].dimensionName |
properties.recommendedActions[*].properties.observedImpact[*].unit | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].observedImpact[*].unit |
properties.recommendedActions[*].properties.recommendationReason | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].recommendationReason |
properties.recommendedActions[*].properties.revertActionDuration | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].revertActionDuration |
properties.recommendedActions[*].properties.revertActionInitiatedBy | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].revertActionInitiatedBy |
properties.recommendedActions[*].properties.revertActionInitiatedTime | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].revertActionInitiatedTime |
properties.recommendedActions[*].properties.revertActionStartTime | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].revertActionStartTime |
properties.recommendedActions[*].properties.score | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].score |
properties.recommendedActions[*].properties.state | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].state |
properties.recommendedActions[*].properties.state.actionInitiatedBy | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].state.actionInitiatedBy |
properties.recommendedActions[*].properties.state.currentValue | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].state.currentValue |
properties.recommendedActions[*].properties.state.lastModified | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].state.lastModified |
properties.recommendedActions[*].properties.timeSeries | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].timeSeries |
properties.recommendedActions[*].properties.timeSeries[*] | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].timeSeries[*] |
properties.recommendedActions[*].properties.timeSeries[*].metricName | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].timeSeries[*].metricName |
properties.recommendedActions[*].properties.timeSeries[*].startTime | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].timeSeries[*].startTime |
properties.recommendedActions[*].properties.timeSeries[*].timeGrain | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].timeSeries[*].timeGrain |
properties.recommendedActions[*].properties.timeSeries[*].unit | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].timeSeries[*].unit |
properties.recommendedActions[*].properties.timeSeries[*].value | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].timeSeries[*].value |
properties.recommendedActions[*].properties.validSince | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].validSince |
properties.recommendedActions[*].systemData | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].systemData |
properties.recommendedActions[*].systemData.createdAt | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].systemData.createdAt |
properties.recommendedActions[*].systemData.createdBy | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].systemData.createdBy |
properties.recommendedActions[*].systemData.createdByType | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].systemData.createdByType |
properties.recommendedActions[*].systemData.lastModifiedAt | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].systemData.lastModifiedAt |
properties.recommendedActions[*].systemData.lastModifiedBy | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].systemData.lastModifiedBy |
properties.recommendedActions[*].systemData.lastModifiedByType | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].systemData.lastModifiedByType |
properties.recommendedActions[*].type | Microsoft.Sql/servers/databases/advisors/recommendedActions[*].type |