Report to show all groups a user belongs

Chukwudi_Awaibe

Pls I need a report that will show all groups that a user belongs including the user's base group

Tim_Hunter

This query only works on oracleselect level as depth,kuc.id,kuc.childid,g.id groupid,g.name groupnamefrom kuafchildren kuc,kuaf gwhere kuc.id = g.idstart with kuc.childid = %1connect by prior kuc.id = kuc.childidorder siblings by childidif you look around the forums you can find examples similar for mssql