Answered Map query result prompt with Runbook parameter

  • Friday, May 11, 2012 9:03 AM
     
     

    Hi,

    I'd like to map the string of one selected query result column to a Runbook parameter, but I really don't know how to proceed. For now, my user would only be able to select one item at the time.

    I saw a lot of things on the Internet. But I haven't been able to understand how does it work.

    If someone would please explain it to me, or give me a link to the exact procedure.

    I'm looking forward from hearing from you guys.

    Best regards,

    Nichoff

All Replies

  • Sunday, May 13, 2012 7:34 PM
    Moderator
     
     

    Hi Nichoff,

    In the current design of the Request Offering and the Query Result question you are not able to do what you are asking for. The result of a Query Result question can only be mapped to the Service Request as a related object.

    Regards
    //Anders


    Anders Asp | Lumagate | www.lumagate.com | Sweden | My blog: www.scsm.se

  • Monday, May 14, 2012 7:35 AM
     
     

    Hi Anders,


    That's a pity. Especially that when you're at the prompts configuration, once you've chosen the Query Result displayed columns. You see each of them with written "(String)".

    That's why I'm a bit confused and why I thought that I could do such thing...

    OK, so the point of my question was to be able to choose an AD group for a new user. And displaying the group names with a Query Result felt nice ! I guess I could just put a drop down menu, but if we add a group, it won't be dynamically added to it. Or... Is there another way to perform what I'd like ?.


    Thank you very much for answering...


    Best regards,

    Nichoff

  • Monday, May 14, 2012 12:40 PM
    Moderator
     
     Answered

    Hi Nichoff,

    You could....

    1. Configure the query result prompt to add selected items as related items of your run book activity.
    2. Pass the activity internal id to Orchestrator
    3. In the beginning of your runbook retrive the related item from the activity (using the internal id of the runbook activity).

    I agree that it would be better to have the possibility to pass the string directly but for now it's not possible.

    Please vote on connect: https://connect.microsoft.com/site799/feedback/details/687914/request-offering-map-prompts-to-properties


    Patrik Sundqvist Solutions Architect @ Gridpro AB Blog: http://blogs.litware.se

  • Monday, May 14, 2012 12:55 PM
     
     

    Hi Patrik !

    Well thank you for the answer ! I'll be looking at that solution very soon ! :)

    Please vote on connect: https://connect.microsoft.com/site799/feedback/details/687914/request-offering-map-prompts-to-properties

    I went, but the page was not found...

    Regards,

    Nichoff

    EDIT : That suits me ! :)


    • Edited by nichoff Monday, May 14, 2012 1:37 PM
    •