Table for Report Schedule Names

I think you are looking for the JOBNAME collumn of ERS_REPORTACCESS

See attached report.

Greg, thank you so much for your effort on this, it is exactly what i was looking for!

Chris

Greg - we don't host our own system so I am putting in a request to access the ERS_REPORTACCESS table and other LBI tables.
The DBA is asking me what schema they live in. Can you help me answer that question?

@Mary: It changes. The default, I believe is RSUSER, (or maybe LRSUSER) but since they installed LBI, they could have installed it into their own naming convention schema.

LAWSONRS is also very common, more so for SQL Server though.

Thanks for your help. He found them under RSUSER. I don't know if they will give us access to them or not.

Not that I would ever condone circumventing proper security protocol of your IT department but.........

if SmartNotifications is on the same server as Reporting Services you can create a JNDI connection in SmartNotificaitons using the JNDI name that you can find in your Reporting Services System Settings page. Then youll be able to query the repository using the infoset editor in SmartNotes.

Well - he gave me access to the rsuser_ers_reportaccess and rsuser_ers_reports tables. Which tables hold the rights, elements, and structures?

not sure what version you are on and this is a fairly old query but this should be a good start. there are several threads about this topic here so do a search and you should be able to get what you need.

SELECT DISTINCT r.STATUS ACTIONMODE, u.USERNAME, r.RULENAME, s.STRUCTURENAME, e.ELEMENTNAME, d.OPERAND, v.ELEMENTVALUE1, d.ELEMENTVALUE2, d.RULEGROUPING
FROM RSUSER.ERS_RULEMAPPINGS m --RIGHTS MAPPING TO USERS
INNER JOIN FSUSER.ENPUSERMAP u ON m.CONSUMERID=u.USERNAME --USERIDS
INNER JOIN FSUSER.ENPGROUPMAP g ON u.USERID=g.USERID--GROUP MEMBERSHIPS IN FS
INNER JOIN RSUSER.ERS_RULEMASTER r ON m.RULEID=r.RULEID --RIGHTS PROPERTIES
INNER JOIN RSUSER.ERS_RULEVALUES v ON r.RULEID=v.RULEID --RIGHTS ELEMENT VALUES
INNER JOIN RSUSER.ERS_STRUCTURE s ON v.STRUCTUREID = s.STRUCTUREID --STRIUCTURE PROPERTIES
INNER JOIN RSUSER.ERS_RULEDETAIL d ON r.RULEID = d.RULEID --RIGHTS DETAILS
INNER JOIN RSUSER.ERS_ELEMENTS e ON d.ELEMENTID = e.ELEMENTID --ELEMENTS DETAILS

If it helps... here's a report that I wrote to audit the rights that we have in place here.. it should be fairly close to "out-of-the-box" and should give you an idea of the tables that you need access to.

Thanks Greg and Matthew - I am requesting access to those tables now so that I can give it a whirl.

Greg,

Thank you. I just converted the data source and the report was out of box! It is very helpful.

Donna

OP here, back for some more good info you folks! This time i need to view the permanent scheduled start dates/times, and it doesn't look like the ers_reports or ers_reportaccess tables contain that info.
Thanks for any help you can throw my way!

Chris

To get this information, and manipulate it as I wanted, I found it easier to write a view, and then write a report that selected from that view.
I've attached the sql (Oracle) used to create the view, and the report that reads the view.

Pure gold Greg, thanks so much! So i won't have to bother you in the future, do you know of an LBI tables entity diagram? We are in sore need of one here at my company.

Here on this site: Under the ERDS tab you can find diagrams for several versions of LBI, and one for MSCM as well.