If you are unable to create a new account, please email bspsoftware@techdata.com

Author Topic: Need to send alert/mail if the report is executed with no data.  (Read 5177 times)

Offline tushar gaurav

  • Senior Member
  • ****
  • Join Date: Jul 2014
  • Posts: 54
  • Forum Citizenship: +0/-0
Hi,

I have scheduled report which sometimes gets executed with no data.
Now I need to have alerts or mail when executed report results in no data.
Can anyone please help in achieving this scenario.

Thanks and Regards
Tushar Gaurav

Offline Nikhil Shenoy

  • Full Member
  • ***
  • Join Date: Sep 2017
  • Posts: 49
  • Forum Citizenship: +0/-0
Re: Need to send alert/mail if the report is executed with no data.
« Reply #1 on: 24 Jan 2018 10:11:34 pm »
Hey Tushar,

You can achieve it through Alert Studio.

You get an option there to send an email when the condition is fulfilled, not fulfilled, in case of error, etc. Refer screenshot

Hope this helps!

Offline ggray

  • Full Member
  • ***
  • Join Date: Mar 2018
  • Posts: 5
  • Forum Citizenship: +0/-0
Re: Need to send alert/mail if the report is executed with no data.
« Reply #2 on: 19 Jul 2018 12:56:29 pm »
How do I get this Alert Studio? I am using 11.0.7. I tried setting this up in Event Studio, but it appears that is nothing more than a scheduled report. I only want it to trigger an Event(Email) when a certain threshold is met.

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,585
  • Forum Citizenship: +674/-10
  • Cognos Software Muppet
Re: Need to send alert/mail if the report is executed with no data.
« Reply #3 on: 20 Jul 2018 03:57:32 am »
How do I get this Alert Studio? I am using 11.0.7. I tried setting this up in Event Studio, but it appears that is nothing more than a scheduled report. I only want it to trigger an Event(Email) when a certain threshold is met.

There is no such thing as Alert Studio. I think the responder means Event Studio...
Meep!

Offline ckapark

  • Associate
  • **
  • Join Date: Oct 2020
  • Posts: 2
  • Forum Citizenship: +0/-0
Re: Need to send alert/mail if the report is executed with no data.
« Reply #4 on: 03 Nov 2020 05:12:20 pm »
Hi, I have the same question.  Unable to open the attachment.  We are on version 10.2.1

Any help greatly appreciated!

Kathleen


Offline BigChris

  • Statesman
  • ******
  • Join Date: Apr 2013
  • Posts: 1,270
  • Forum Citizenship: +91/-0
Re: Need to send alert/mail if the report is executed with no data.
« Reply #5 on: 04 Nov 2020 12:20:27 am »
You would need to create an event in Event Studio for this. Essentially, you'd count the records and if the result is zero (or is missing) then you'd send out the email.