locked
Opalis Workflow Status RRS feed

  • Question

  • Hi,

    We are starting opalis policy using powershell from aspx page and we want to track its workflow staus. Is it possible to get?

    Thanks in advance

    Cheers

    Hari

    Thursday, August 16, 2012 10:51 AM

Answers

  • Hello,

    if you are Using Opalis (NOT Orchestrator) you can interact with the Operator Console using WSDL.

    The WSDL gives you some Status Information for the Policies (like "getPolicyInstancesByPolicy") .

    WSDL Policy Status

    Regards,

    Stefan

     


    German Orchestrator Portal , My blog in English

    Thursday, August 16, 2012 11:54 AM
  • Hello Hari Rama,

    ok, I was not sure if you use wsdl or SQL in your powershell.

    I think this query will help you:

     
    SELECT     POLICIES.Name AS PollicyName, OBJECTS.Name AS Objectname, OBJECTINSTANCES.ObjectStatus, OBJECTINSTANCES.StartTime, OBJECTINSTANCES.EndTime, 
                          POLICYINSTANCES.TimeStarted
    FROM         OBJECTS INNER JOIN
                          OBJECTINSTANCES ON OBJECTS.UniqueID = OBJECTINSTANCES.ObjectID INNER JOIN
                          POLICIES INNER JOIN
                          POLICYINSTANCES ON POLICIES.UniqueID = POLICYINSTANCES.PolicyID ON OBJECTINSTANCES.InstanceID = POLICYINSTANCES.UniqueID
    WHERE     (POLICIES.Published = 1) AND (POLICYINSTANCES.TimeEnded IS NULL)
    ORDER BY PollicyName, OBJECTINSTANCES.StartTime, OBJECTINSTANCES.EndTime

    Regards,

    Stefan


    German Orchestrator Portal , My blog in English

    Thursday, August 16, 2012 2:18 PM

All replies

  • Hello,

    if you are Using Opalis (NOT Orchestrator) you can interact with the Operator Console using WSDL.

    The WSDL gives you some Status Information for the Policies (like "getPolicyInstancesByPolicy") .

    WSDL Policy Status

    Regards,

    Stefan

     


    German Orchestrator Portal , My blog in English

    Thursday, August 16, 2012 11:54 AM
  • Hello Stefan,

    Thanks for your reply.. How can i track this in my aspx webpage?

    I am looking at DB level, if the status of each object in a running workflow is updated in Opalis DB then it will be easy for me to retrieve its status into my web page by a query but i am not getting which DB table to track the workflow status. 

    Can you help me with respect to this.

    Cheers

    Hari Rama K

    Thursday, August 16, 2012 1:25 PM
  • Hello Hari Rama,

    ok, I was not sure if you use wsdl or SQL in your powershell.

    I think this query will help you:

     
    SELECT     POLICIES.Name AS PollicyName, OBJECTS.Name AS Objectname, OBJECTINSTANCES.ObjectStatus, OBJECTINSTANCES.StartTime, OBJECTINSTANCES.EndTime, 
                          POLICYINSTANCES.TimeStarted
    FROM         OBJECTS INNER JOIN
                          OBJECTINSTANCES ON OBJECTS.UniqueID = OBJECTINSTANCES.ObjectID INNER JOIN
                          POLICIES INNER JOIN
                          POLICYINSTANCES ON POLICIES.UniqueID = POLICYINSTANCES.PolicyID ON OBJECTINSTANCES.InstanceID = POLICYINSTANCES.UniqueID
    WHERE     (POLICIES.Published = 1) AND (POLICYINSTANCES.TimeEnded IS NULL)
    ORDER BY PollicyName, OBJECTINSTANCES.StartTime, OBJECTINSTANCES.EndTime

    Regards,

    Stefan


    German Orchestrator Portal , My blog in English

    Thursday, August 16, 2012 2:18 PM
  • Thanks stefan,

    Let me give a try and will update you...

    Friday, August 17, 2012 11:15 AM