• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Reporting from LBI Data Schemas

 3 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Robby
Veteran Member
Posts: 87
Veteran Member
4/3/2013 5:56 PM
Hi All,
It seems that it could be very useful to know things like "Who is in This or That Custom Group", or when was the last time so-and-so Infoset was updated?

So, my question is this....Do you have some queries against the LBI Schemas that have proven useful for your end users or for your "LBI Administrator"?

Care to share :-) ?
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
4/3/2013 6:07 PM
Here's one...
https://www.lawsonguru.co...s-rights-in-crystal/

I know I've got tons more, but not always against the LBI schemas, but rather against our AD where the Groups and Roles are stored at... Those have been exceptionally useful. Let me see if I can dig them up. **Found**

Like: https://www.lawsonguru.co...curity-group-in-lbi/
Or: https://www.lawsonguru.co...-report-users-share/
Robby
Veteran Member
Posts: 87
Veteran Member
4/3/2013 6:37 PM
Thanks Greg :-)

I'll take a look..........

Anybody else?
Georgette
Veteran Member
Posts: 52
Veteran Member
4/4/2013 10:31 AM
I downloaded the information into an Access database and developed queries to see who has what and when. This way I have a static source to compare to the system for audit purposes. Also, it makes it a snap when I am setting up new users as to whether they can join a group or be stand-alones. I edit the Access database at the same time I make changes in LBI. At any time I can download the system data and run compares to the Access data.