CODEWITHSUNDEEP
azureazure-resource-graph
Kamsiinov
Kamsiinov

Reputation: 1490

Azure resource graph get assigned and deprecated policies

My current query is:

policyresources 
| where type =~ 'microsoft.policyinsights/policystates'
| extend
    policyDefinitionId = tostring(properties.policyDefinitionId),
    policyAssignmentScope = tostring(properties.policyAssignmentScope),
    policyAssignmentName = tostring(properties.policyAssignmentName)
| project policyDefinitionId, policyAssignmentScope, policyAssignmentName
| join kind=leftouter (
    policyresources
    | where type =~ "microsoft.authorization/policydefinitions"
    | extend 
    description = tostring(properties.description),
    displayName = tostring(properties.displayName)
    | where displayName contains 'deprecated'
    | project id, description, displayName
    ) on $left.policyDefinitionId == $right.id

But I just get "An unexpected query execution error occurred. Please try again later. (Code:UnexpectedQueryExecutionError)". What I am doing wrong here and how could I get the information I need?

Upvotes: 0

Views: 211

Answers (0)

Related Questions