Jump to content

Reporting on Report Recipients


AlexOnTheHill
 Share

Recommended Posts

I was wondering if it is possible to report on existing reports which have a recipient.

I am looking for reports scheduled for a specific recipient who has left so that I can check whether those reports are still needed and transition them to a new recipient if they are.

I can see easily enough how to filter by the person who created and modified a report but not the recipients.

I had a run through database direct but didn't see a table that listed recipients.

Do I need to go and check the our 436 reports manually? I hope not

Any suggestions would be gratefully received.

Link to comment
Share on other sites

Hi @AlexOnTheHill

This information is stored within the h_sys_reports table, in an column called h_definition. You'll notice that this column actually contains all sorts of information relating to the definition of the report, not just scheduled recipients. 
Due to this, to find what you need you would need to use an "Is Like" operator in the filter - so it can look at the whole string of text in h_definition and see if there is a match. In terms of the details held against the scheduled recipient, it actually stores their Name, Hornbill User ID, and Email Address. 

I have attached up a quick example report example you could load onto your instance that prompts the person running the report to enter the email address of the recipient who may be scheduled to recieve some reports - and the results should return the titles of any reports that meet this criteria. 

Hope this helps

Bob

reports-by-scheduled-user-prompt.report (1).txt

  • Like 2
Link to comment
Share on other sites

Thank you!

I had scoured through the definition values and not seen the email or user ID and searched through the text in that field for that information and found no results. I had looked at it on database direct and again found no results but this has worked. What a relief!

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...