Try using “CTM:SupportGrpAsscFuncRoleLkUp”. The form provides Full name, Login ID, Company, Support Org, Support Group, Support Gr ID, Assignee Groups number & Functional Role of the user. You can create your report to sort on the Full Name or Login ID or PIVOT on the same data in Excel after a CSV export.
Thank you, Sandra Hennigan Remedy Developer From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Tuesday, August 5, 2014 5:41 PM To: [email protected] Subject: Re: Queue Report w/ Members ** Generate a join form that joins the source of both forms, and report on the join form On Aug 5, 2014 3:37 PM, "Tim Buchanan" <[email protected]<mailto:[email protected]>> wrote: Hello all, I am trying to figure out the best way to generate a report out of Remedy 7.0 that will not only tell me all of our support queues, but also who is in each queue. This sounds so painfully straight forward but every form I go looking on can't seem to report both pieces of information together. Anyone out there who can tell me the best way to accomplish this? I would be forever grateful. Tim B. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> "Where the Answers Are, and have been for 20 years" _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"

