Workflow and ServiceDesk Community

 View Only
  • 1.  Altiris Workflow - Web Form User Input to Query CMDB

    Posted Jan 29, 2016 03:18 PM

    Hello,

    I am new to Workflow and we are creating a Web Form workflow in Workflow 7.5 and would like to take the user's input from a form (created with form builder component) and use that input to search the CMDB for that value.

    For example, if the user entered a User Name value of 'xyz' then we would like to search for that value in the CMDB with a query like the one below:

    SELECT dbo.vuser.Name
    FROM dbo.vuser
    WHERE (dbo.vuser.Name LIKE 'xyz')

    How can we do this using Workflow? Is there a component that allows this search?

    Thank you for any input!



  • 2.  RE: Altiris Workflow - Web Form User Input to Query CMDB
    Best Answer

    Posted Jan 30, 2016 04:19 PM
    There are SMP components you could use, search for user and make sure you have the Create SMP Credentials at the beginning of your WF. Or you could build your own Integration component using the SQL Generator https://www-secure.symantec.com/connect/articles/integrating-sql-data-workflow http://atmaworkflow.com/2014/10/29/concepts-primer-integrating-sql-data-with-symantec-workflow/


  • 3.  RE: Altiris Workflow - Web Form User Input to Query CMDB

    Posted Feb 01, 2016 07:47 AM

    Concur with AlexHedley. Just use a SQL Generator component and run through the wizard.



  • 4.  RE: Altiris Workflow - Web Form User Input to Query CMDB

    Posted Feb 05, 2016 11:25 AM

    Thank you both for the prompt responses! I really appreciate the answers. We followed the steps from the Integrating SQL Data process link but we are not seeing the option to pull the data from the query specific results.

    To be more specific, in the webform, users enter a value that is used as the variable "@UserID". The next component in the workflow is an automated email. We want the email component to pull values from the CMDB based on the @UserID variable. We don't see any specific values under the UserID. I attached a screenshot of what we see in the left margin of the email component.

    How can I get the query results to populate as specific options in the email component? I am attaching a snapshot of our workflow also.

    Any help is greatly appreciated!



  • 5.  RE: Altiris Workflow - Web Form User Input to Query CMDB

    Posted Feb 05, 2016 11:30 AM

    Hello A.K.M. - i'm glad to do a quick webex to help you, if you think it'd be beneficial.



  • 6.  RE: Altiris Workflow - Web Form User Input to Query CMDB

    Posted Feb 05, 2016 05:05 PM
      |   view attached

    Hello A.K.M.

    See if my demo package help you.

    1. Publish the CT.GetCMDBInformation 

    2. Open Form CT.GetUserFromCMDB
    2.1 Change set connection string from GetUser and SMTP Server Name on Send Email Component

    This form will execute a simple search in cmdb view vuser based on User Name input in form 1 and will display all results in a listbox on form 2.
    the selected user in form 2 will send an email to himself. 

    GetUserFromCMDB.jpg

    Attachment(s)

    zip
    GetCMDBUser.zip   116 KB 1 version


  • 7.  RE: Altiris Workflow - Web Form User Input to Query CMDB

    Posted Feb 10, 2016 04:18 PM

    Thank you to everyone!

    After setting up the integration components with a SQL Generator, we still had issues. At that point, we contacted Symantec and it appears that we will need to upgrade Workflow for the form to work properly.

    However, the SQL Generator solution should work in theory! Thank you all again