Who's On?

	Membership:
	Latest: Saef
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5226

	People Online:
	Visitors: 310
	Members: 0
	Total: 310

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

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

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

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

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.