internal/queries/AzureResourceGraph.ApiConnections.Summarized.txt
|
resources
| where type == 'microsoft.web/connections' ##FILTERS## | project id=tolower(id), name, resourceGroup, subscriptionId | join kind= leftouter ( resources | where type == 'microsoft.logic/workflows' ##FILTERS## | mv-expand Conn=todynamic(properties)["parameters"]["$connections"]["value"] | where notnull(Conn) | extend connectionId=tolower(extract("\"connectionId\":\"(.*?)\"", 1, tostring(Conn))) | project connectionId, LogicAppId=id, LogicAppResourceGroup=resourceGroup, LogicApp=name ) on $left.id == $right.connectionId | project Id=id, Name=name, ResourceGroup=resourceGroup, SubscriptionId=subscriptionId, LogicAppId | summarize LogicAppReferences=countif(strlen(LogicAppId) > 0) by Id,Name,ResourceGroup,SubscriptionId | order by ['Name'] asc |