Report to know the total list of groups

Dhana_Marothu

hi , can anyone help me to come up with a report to know the total list of groups, its members and it's subgroup if any?

i am using CS 10.5 version .

Thanks,

Lakshmi

Alok_Varma

Try this SQL Server Query : 

Select 
KC.ID 'Group ID' ,
K.Name 'Group Name', 
K1.ID 'Child ID' ,
K1.Name 'Child Name', 
CASE WHEN K1.GroupID IS NULL THEN 'SubGroup' ELSE '' END 'SubGroup'
FROM KUAFChildren KC
Inner Join KUAF K ON KC.ID =K.ID  
Left Outer Join KUAF K1 ON KC.ChildID  =K1.ID  
Where K.Type in (0,1) And K1.Type in (0,1)
Order by 1,3