Workflow and ServiceDesk Community

 View Only

  • 1.  Comparing two values from two different database tables in workflow

    Posted Jul 18, 2014 07:19 AM

    HI,

    I have created a workflow for deploying the software.Now I want to check whether the software is installed or not from the Inv_AddRemoveProgram table. So how do I Select the software name from AddRemove table and check it through SQL Query. If it is present then update the deployment status column present in other table.

    Thanks.



  • 2.  RE: Comparing two values from two different database tables in workflow

    Posted Jul 18, 2014 07:29 AM

    You have 2 options to run SQL queries against a DB. You can either use the SQL library by loading Logicbase.Components.SQL, but it is deprecated. The preferred method to running a SQL query is using the SQL generators.

    Create a new Integration library, and choose the SQL Query/Script generator. Using the wizard, you can specify whatever SQL you wish to run. The SQL you specify can even include input parameters by specifying the parameter as @blah (where blah is the name of the parameter coming in - similar to SQL syntax). At the end of the wizard you should have generated components that run your custom SQL.



  • 3.  RE: Comparing two values from two different database tables in workflow

    Posted Jul 18, 2014 10:07 AM

    I have a similar requirement to ensure the deployed software has been installed.  I created a Integration project that executes the sp_SWM_SoftwareComplianceStatus stored procedure.

    My workflow adds computers to Filters to achieve deployment.  In order to determine if the software has been installed the basic logic is:

    For each request detail

        Get the Filter guid

        For each Policy associated with the Filter guid

            Execute the Software Compliance Report

            If all Policies associated with this Filter/computer combination are compliant

                The software has been installed

            Else

                The software has not yet been installed.

    I run this process every couple of hours to process all outstanding requests (waiting for confirmation).  As details are found to be compliant, I change their status to complete.  Once all details are complete the request is marked as complete.

    See the attached package files.

    Attachment(s)

    package
    DeployComputerToSMPFilterInt.package   134 KB 1 version
    package
    SOD_DeploymentCompliance.package   2.59 MB 1 version