All:
I have been tasked with creating a report containing the LBI report number, LBI Report name, LBI report owner, LBI report schedule, and LBI Report Users.
I can pull the first three out of the ERS_REPORT table, but where would I find the schedule and report users?
Thinking a Y/N flag would suffice for the schedule, but the users may want Weekly, Daily, time it runs, etc.
The report users- ?? Where do I go for those, and how do I link the tables appropriately?
Thanks for any help given,
-Greg