Reporting from LBI Data Schemas - LawsonGuru.com

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Robby

Veteran Member

Posts: 87

New Poster

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

MVP

New Poster

Engaged Reader

Avid Reader

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

New Poster

4/3/2013 6:37 PM

Thanks Greg :-)

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

Anybody else?

Georgette

Veteran Member

Posts: 52

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.