LBI report information in a report

 4 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member

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

Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
More info found: I can get the schedule name from EJS_TRIGGERS or EJS_CRON_TRIGGERS, but how do I tie either of those tables back to ERS_REPORT ? The only thing I can guess (and it is strickly a guess) is via another table.

Much appreciation for any suggestions,
-Greg
Deleted User
New Member Send Private Message
Posts: 0
New Member
Greg, The ERS_REPORTACCESS table contains an ACCESS_TYPE and ACCESS_VALUE column which states the reports access rights per user or group. This information can also be mapped to the ERS_LISTUSERS table.
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
Thanks, Chad. That is very helpful. Now if I could get one of those TRIGGER tables tied to those other two, I'd be set.
Anyone out there with help?

Thanks again,
-Greg
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
Got it all!! Thanks much.

Figured out that ERS_REPORTACCESS.JOBNAME is the schedule name, so no need for the other tables.

Thanks again!!