SCSM Group / Pulldown

CaterhamITSupport

Dear All,

Is there a way to pull SCSM Group members through using a pulldown?

For example when clicking on a the list it will show all members of the SCSM group?

Thanks

Daniel

Peter_Miklian

What do you mean by "SCSM Group"? AD group synced to SCSM users? When you open any group in \Configuration Items\Configuration Items\Users you won't see any membership information. Do you want to publish current members of some group in dropdown of request offering?

Or \Library\Library\Groups? Thanks.

CaterhamITSupport

Dear Peter,

Yes I want to publish members of a group in a drop down list in the request offering.

Thanks for the help.

Daniel

Peter_Miklian

Unfortunately I don't think you could pull AD group membership and put it into simple list (dropdown)/query in the request offering to let end user choose member form in the portal. I'd like to be wrong, wait for other answers :)

Justin_Workman

You could use the QueryList control from the RO Toolbox:

Steps I took:

1. Install RO toolbox (link above).
2. Create a dashboard query that returns group membership with groupName as a dashboard parameter (query in screenshot).
3. Get the Id of the dashboard query to feed to the query list control in the RO toolbox
4. Appended the groupName query parameter to the Id in the QueryLIst JSON

Mike_Line

select u.DisplayName

Attempted to Execute the above line, and received

"Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "u.DisplayName" could not be bound."

Mike_Line

Mike_Line

Nevermind, I've resolved it. the database name you are using in your screenshot, does not work in my database.

In my environment, I needed to add 'dbo.' (without the single quotes, period at the end) in front of GroupMembership_CI$DomainGroup_CI$User