1

I want to send a single status email having all pipelines status, without using logic apps. Is it possible to share it from dashboard or kusto query output?

I set the alert but it is sending 2 mails(activate, deactivate) for each pipeline status individually. In that case so many status mails are coming.

Ivan Glasenberg
  • 29,865
  • 2
  • 44
  • 60
Neha
  • 87
  • 1
  • 2
  • 7
  • what's the pipeline? – Ivan Glasenberg Mar 22 '21 at 06:50
  • Azure data factory pipelines status I want to send in an email.. – Neha Mar 22 '21 at 06:54
  • Not sure I understood you. you set an alert by sending email if the status is activate or deactivate. and suppose you have 4 pipelines, each pipeline will send 2 alerts mail, so you totally get 8 emails, right? – Ivan Glasenberg Mar 22 '21 at 07:42
  • Do you want get all the pipeline status in one emails? – Leon Yue Mar 22 '21 at 07:58
  • Yes Leon.. I want to send one status mail for all pipelines. Lets say I have 15 pipelines so in the mail I want to send 15 pipelines status- Succeeded/failed. Is there any way if we can share dashboard workbook/query result in the mail ? – Neha Mar 23 '21 at 09:23

1 Answers1

0

Please correct me if I misunderstood you. You set an alert by sending email if the status is activate or deactivate. and suppose you have 4 pipelines, each pipeline will send 2 alerts mail, so you totally get 8 emails.

If that's the case, you don't have an option to send a single status email having all pipelines status. The alert will periodically check the status for each pipeline, and if the condition is met, an alert will be sent. There's no way to configure this.

Dharman
  • 30,962
  • 25
  • 85
  • 135
Ivan Glasenberg
  • 29,865
  • 2
  • 44
  • 60
  • Yes, as per alert rule which I created I am getting 2 mails.. you understood it correct. Is there any other way where we can get one mail only having status of all pipelines? – Neha Mar 23 '21 at 09:26
  • @Neha we cannot do that. It's based on your query which is used to set the alert. If your query checked these status(like both activate / deactivate), then during alert scans, if any condition is met, it will send the related alert. – Ivan Glasenberg Mar 23 '21 at 09:31
  • @Neha since it's by designed, could you please accept it as answer? Thanks. – Ivan Glasenberg Mar 31 '21 at 06:36
  • @ Ivan, I am still waiting for the answer or other possible ways to achieve it. – Neha Apr 01 '21 at 05:45