Need list of all workflow in environment with latest k2 Version

1. You can try using the following SmartObjects in the following category to see if it has the data you are looking for:

System > Management > Workflows > SmartObjects > Process

System > Management > Workflows > SmartObjects > Process Set

2. You can try the following SQL query against the K2 database:

SELECT 
    [PS].[Folder],
    [PS].[Name],
    [Version] = [P].[Ver],
    [Type] = CASE ISNULL([PV].[Name], [LPV].[Name])
        WHEN 'ProcessView' THEN 'Thick Client'
        WHEN 'WebView' THEN 'Silverlight Designer'
        WHEN 'ShapesView' THEN 'HTML5 Designer'
        ELSE ISNULL([PV].[Name], [LPV].[Name])
    END
FROM 
    [Server].[ProcSet] AS [PS]
INNER JOIN 
    [Server].[Proc] AS [P]
    ON [P].[ID] = [PS].[ProcVerID]
LEFT JOIN
    [Server].[ProcView] AS [PV]
    ON [PV].[ProcID] = [P].[ID]
    AND [PV].[Default] = 1
LEFT JOIN
    [ServerLog].[ProcView] AS [LPV]
    ON [LPV].[ProcID] = [P].[ID]
    AND [LPV].[Default] = 1
ORDER BY 1, 2

We won’t be able to really tell on which version a workflow was created in, but a 'HTML5 Designer' can only be created after your environment was upgraded to a K2 Five.

Support for 'Silverlight Designer' stopped in K2 5.5, so it would have been created pre-5.5.

'Thick Client' or K2 Studio/K2 for Visual Studio can be created from K2 4.6 to current K2 version as it has not been removed yet.

Hi @ruchiPan 
Did this help solve your question? 

Hello @TinTex, Thank you so much for the response .

From your query I can get the HTML 5 which is k2 five WF but I'm not able to figure out for 4.6 WF . 

Could you please help me on this .

Thank You,

Ruchi Agarwal

Unfortunately, as Silverlight workflow can be created up to version 5.5 and Thick Client workflow can still be created up to the latest version, there isn’t really a way to tell if they were in fact created while your servers was on 4.6 or after it was upgraded to 5.5.

You can try looking at the date for the deployed version to see when they were deployed.

https://help.nintex.com/en-US/nintexautomation/userguide/5.7/Content/K2-Management-Site/Workflow_Server/Versions.htm

Silverlight and Thick Client workflow are ‘legacy’ and HMTL5 workflow are the newest type of workflow.