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

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") .

Regards,

Stefan

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

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

Thanks stefan,

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