My Requirement: I need to send log analytics query result to Group Email basically we are using Azure Data Factories to log all "Pipeline Metrics" and "Activity Metrics". To send Email I setup one rule and one "Action Group" and for this "Action Group" initially i setup my Emailid then i Received Email Successfully.However when i give Group Email Id(basically i created one group in outloook) it is not sending. Otherway i tried the below solution to send group Email
1.If i select "Contributor" Role for "Action Group" then it is sending email to all contributor roles .
2. But i want to send email to these roles "Monitoring Contributor" or "Monitoring Reader" or "Reader" . I tried, but didn't Received mails.
we tried Logic Apps to send Group Email. It worked basically But we don't want use Logic Apps(cost issue).
So, I want solution to send Group Email.
Query :
ADFPipelineRun
|join
(
ADFActivityRun
|where Status == "Succeeded" or Status == "Failed"
|project ActivityStatus = Status,PipelineRunId,ActivityRunId ,ActivityName,ActivityStartTime=Start ,ActivityEndTime=End,FailureReason=ErrorMessage
)
on $left.CorrelationId == $right.PipelineRunId
|project PipelineName,ActivityName,ActivityStatus,ActivityStartTime,ActivityEndTime,FailureReason
Here is image for action group role selection:
Please help me out from this problem. Thanks in advance!