Group Leaders Report

Colleen_Yorke_(infusa01admin_-_(deleted))

I need to find who the Group Leaders are and what Groups they are leaders of. I would need SQL Statements to do this. We are using version 9.2 of LiveLink. Any help on how to get started with this would be much appreciated.

Chad Latka

Colleen:This may not be what you are looking for, but...In our Livelink 9.2 Environment, we create groups like this:Group Name (GL) - and then add the group leaders who would administer the coordinating group called Group Name. Then we add the Group Name (GL) group as a user and set it as the "group leader", if that makes sense since only one person can be a group leader at a time, this is a work around.Here is the SQL to query on what we do:SELECT TOP 100 PERCENT mssqlsa.KUAF.Name, KUAF_1.LastName, KUAF_1.FirstName, KUAF_1.Name AS [5&2], KUAF_1.MailAddressFROM mssqlsa.KUAF INNER JOIN mssqlsa.KUAFChildren ON mssqlsa.KUAF.ID = mssqlsa.KUAFChildren.ID INNER JOIN mssqlsa.KUAF KUAF_1 ON mssqlsa.KUAFChildren.ChildID = KUAF_1.IDWHERE (mssqlsa.KUAF.Name LIKE '%GL%')ORDER BY mssqlsa.KUAF.Name, KUAF_1.Name