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.

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