Jump to content

Only E-mail Report if there is a record count >0


Recommended Posts

I am unsure if this is an enhancement request, if I am missing a setting or if there is a better way to achieve the same end result.

We have a number of reports running on a weekly basis to highlight where there are issues in the system that require manual intervention and fixing. For example:

  • Assets with duplicate names.
  • Users with more than one active account.
  • Requests assigned to a team but without an owner.
  • Users with missing Organisations, manager info etc.

The reports are either emailed to key individuals or into the system to raise a Request. We have been running these for several months and now find that quite often there are no records to report (which is of course good news). However the reports still run and email the pdf/csv.

Ideally we only want these reports to be sent out if there are records which need attention ie record count >0. I can't see any setting for this. Alternatively is there a different way to approach the problem?

 

Link to comment
Share on other sites

On 7/2/2022 at 11:58 AM, Frank Reay said:

Ideally we only want these reports to be sent out if there are records which need attention ie record count >0

Unfortunately that's not how a report works.
You're asking the question "How many ... ?" and "Zero" is a perfectly valid answer. For that reason I don't think it's going to work as an Enhancement Request either.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...