Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
Table for Report Schedule Names
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Wayne Willis
Past 24 Hours:
0
Prev. 24 Hours:
1
Overall:
5190
People Online:
Visitors:
244
Members:
0
Total:
244
Online Now:
New Topics
Lawson Landmark
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
IPA/ProcessFlow
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1354
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson Business Intelligence/Reporting/Crystal
Table for Report Schedule Names
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
clb393
Basic Member
Posts: 24
8/19/2013 12:58 PM
Hello! I would like to know what table in LBI i can query that lists Report Schedule Names. Please see above for a screen print of what i am referring to.
Thanks,
Chris
Greg Moeller
Veteran Member
Posts: 1498
8/19/2013 1:16 PM
I think you are looking for the JOBNAME collumn of ERS_REPORTACCESS
See attached report.
Attachments
ReportsSchedulesReportUsers.rpt
clb393
Basic Member
Posts: 24
8/22/2013 1:32 PM
Greg, thank you so much for your effort on this, it is exactly what i was looking for!
Chris
Mary Porter
Veteran Member
Posts: 337
10/31/2013 6:38 PM
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?
Greg Moeller
Veteran Member
Posts: 1498
10/31/2013 7:03 PM
@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.
Matthew Nye
Veteran Member
Posts: 514
10/31/2013 7:15 PM
LAWSONRS is also very common, more so for SQL Server though.
Mary Porter
Veteran Member
Posts: 337
10/31/2013 7:51 PM
Thanks for your help. He found them under RSUSER. I don't know if they will give us access to them or not.
Matthew Nye
Veteran Member
Posts: 514
10/31/2013 8:10 PM
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.
Mary Porter
Veteran Member
Posts: 337
10/31/2013 8:28 PM
Well - he gave me access to the rsuser_ers_reportaccess and rsuser_ers_reports tables. Which tables hold the rights, elements, and structures?
Matthew Nye
Veteran Member
Posts: 514
11/1/2013 11:50 AM
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
Greg Moeller
Veteran Member
Posts: 1498
11/4/2013 2:55 PM
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.
Attachments
MaintainRightsTry2.rpt
Mary Porter
Veteran Member
Posts: 337
11/11/2013 7:05 PM
Thanks Greg and Matthew - I am requesting access to those tables now so that I can give it a whirl.
Donna
Veteran Member
Posts: 110
5/14/2014 8:29 PM
Greg,
Thank you. I just converted the data source and the report was out of box! It is very helpful.
Donna
clb393
Basic Member
Posts: 24
7/2/2014 12:15 PM
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
Greg Moeller
Veteran Member
Posts: 1498
7/2/2014 1:17 PM
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.
Attachments
ghs_lbi_rs_schedules.txt
ReportSchedules.rpt
clb393
Basic Member
Posts: 24
7/2/2014 2:03 PM
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.
Greg Moeller
Veteran Member
Posts: 1498
7/2/2014 2:16 PM
Here on this site: Under the ERDS tab you can find diagrams for several versions of LBI, and one for MSCM as well.
You are not authorized to post a reply.