Home General Discussion

SCSM Group / Pulldown

CaterhamITSupportCaterhamITSupport Member Advanced IT Monkey ✭✭✭

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

Answers

  • Peter_MiklianPeter_Miklian Customer Advanced IT Monkey ✭✭✭

    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.

  • CaterhamITSupportCaterhamITSupport Member Advanced IT Monkey ✭✭✭

    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_MiklianPeter_Miklian Customer Advanced IT Monkey ✭✭✭

    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_WorkmanJustin_Workman Cireson Support Super IT Monkey ✭✭✭✭✭

    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_LineMike_Line Customer IT Monkey ✭

    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_LineMike_Line Customer IT Monkey ✭


  • Mike_LineMike_Line Customer IT Monkey ✭

    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

Sign In or Register to comment.