Live report to find Group Leaders in the system

Navneet_Kaur

Hello all, I am looking for a live report that can list all group leaders in the system, along with the folder names where they the group leaders.In our current set up, we usually make a group as Group Leader, and add this group as an individual while electing as GL. (I hope i am not confusing)we want to simplify the process, so taht users know who is teh group leader to the folder where they want acess, and can approach them directly.Any help guiding me, how to get this information.

Martin_Gäckler

Hello,This is the SQLselect k1.name, k2.firstname, k2.lastnamefrom kuaf k1, kuaf k2where k1.deleted=0and k1.leaderid = k2.idHope this helpsMartin