How to determine which tool is used to deployed which workflows on K2

Topic

Workflows deployed with K2 Studio or Visual Studio cannot be opened with K2 Designer. And workflows deployed with K2 Designer cannot be opened in K2 Studio or Visual Studio. With so many workflows being deployed, it can become difficult to keep track exactly which workflow is deployed with which tool.

If you need to make changes to your workflow, you need to open the workflow using the exact same tool used to deploy it in the first place.

Instructions 

You can run the following SQL query on your K2 database to list out all your deployed workflows, along with the tool used to deploy each workflow.

SELECT [PS].[Id] ,
       [PS].[Folder],
       [PS].[Name],
       [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

Thick Client represents K2 Studio/Visual Studio.

Silverlight Designer represents the silverlight designer introduced in K2 blackpearl. If you have deployed workflows with K2 Designer when your environment was still on K2 blackpearl, the Type column will show Silverlight Designer.

HTML5 Designer represents the new HTML5 designer introduced in K2 Five. These workflows are created and deployed with K2 Designer on K2 Five.