Workflow Soluiton

This is the first part of a two-part question. I broke them apart to help people feel they can answer one piece and not the other. What I am looking to do is to enumerate the members of a specific queue and then populate a drop-down list with those members on a webform. I was able to do this in 7.1 by using the LogicBase.Components.Ensemble.UserMan.SearchUser, entering the group name and then outputting that to a variable. Now, that component doesn't exist and if I copy it in it won't return anything and if it did it wouldn't really be what I want since I need the members of the queue.

Does anyone know how I can get all members of a specific queue and output those to a drop-down list?

This is a cross-posting to see if I can get more eyes on the issue between Workflow and ServiceDesk.

Hi jpellet2 - this script should get it for you in 7.5.  Were you looking to avoid custom SQL to accomplish this?

select ISQ.QueueName
        ,U.PrimaryEmail 
from ServiceQueueGroupMap SQ
join ImServiceQueue ISQ 
    on ISQ.ImServiceQueue_id = SQ.ImServiceQueueId
    and ISQ.QueueName = 'Default Incident Queue' --set value or variable here
join [Group] G 
    on SQ.GroupId = G.GroupID
join [UserGroup] UG 
    on UG.GroupID = G.GroupID
join [User] U 
    on UG.UserID = U.UserID
order by U.PrimaryEmail

of course, you can add the U.UserID to the select list so you have a value to use in a processmanager fetch component, or you can just include the entire U.* user table result for whatever you need to use the user value for.  Add the U.PrimaryEmail or whatever reference column you want to use, to the drop-down list.

send me a private message here if you want to do a quick webex, and i can show you how to incorporate this into your workflow.

-africo

Although the SQL would work, I was looking more for a workflow answer. Because of my cross-post the answer can be found here: https://www-secure.symantec.com/connect/forums/help-getting-members-service-queue