End-of-Life for Anthology Student Activities (V1)

Script to Locate V1 Activities

To locate all occurrences of V1 activities in your workflows, you can run the script below. The script identifies the workflows using V1 activities and, on a per-workflow basis, lists the V1 activities that are being used. It also gives a count of how many times each activity occurs in the workflow so that you know how many occurrences to look for in the workflow while updating it.

If you wish to validate the script in an environment, you can do so by opening the XAML for the workflow in a text editor and searching for all occurrences of V1 activity elements in the document. These elements will have the following namespace prefixes:

• cnc
• cnw
• cnwc
• cnws
• cnwsa
• cnwsa1
• cnwss
• cnwss1

Example:

<cnw:LookupGroup DisplayName="Lookup Pending App Group" Group="[groupadd]" GroupId="314411" sap2010:WorkflowViewState.IdRef="LookupGroup_1" />

LookupGroup is a V1 activity in the XAML because it starts with “cnw:” which is the Cmc.Nexus.Workflow namespace.

The results of the manual search should match the results shown by the script in terms of what activities are identified, and how many of each there are.

/******************************************************************
**
** Find Workflows Using V1 Activities
**
** Author: Mike Carter, Technical Account Manager, Anthology Inc
** Date: 7/16/2021
** 
** Locate enabled workflows which are using V1 activities and,
** on a per-workflow basis, list each Activity name and how
** many occurrences of each activity there are in the workflow  
**
** Identify the V1 activites by the following namespaces:
**    Cmc.Nexus.Converters
**    Cmc.Nexus.Workflow (and also namespaces prefixed by this)
**
*******************************************************************/

declare
	 @WorkflowName nvarchar(max)
	,@EnabledVersion int
	,@xaml xml

if object_id('tempdb..#AffectedWorkflows') is not null drop table #AffectedWorkflows
select 
	 WorkflowDefinition.Name as WorkflowName
	,WorkflowDefinitionVersion.Revision as EnabledVersion
	,cast(WorkflowDefinitionVersion.Xaml as XML) as xaml

into #AffectedWorkflows

from
	WorkflowDefinition
	inner join WorkflowDefinitionVersion on WorkflowDefinitionVersion.WorkflowDefinitionId = WorkflowDefinition.Id

where
	WorkflowDefinitionVersion.IsEnabled = 1 
	and (		
		WorkflowDefinitionVersion.Xaml like '%clr-namespace:Cmc.Nexus.Converters%'
		or WorkflowDefinitionVersion.Xaml like '%clr-namespace:Cmc.Nexus.Workflow%'
	)

--select * from #AffectedWorkflows order by WorkflowName

if object_id('tempdb..#Output') is not null drop table #Output
create table #Output (WorkflowName nvarchar(max), EnabledVersion int, ActivityName varchar(50), Occurrences int)

declare Records_Cursor cursor local fast_forward for 
	select WorkflowName, EnabledVersion, xaml from #AffectedWorkflows
open Records_Cursor

while 1=1
begin
	fetch next from Records_Cursor INTO @WorkflowName, @EnabledVersion, @xaml
	if @@FETCH_STATUS <> 0 
		break

	;with walkXML
	as
	(	select 
			 startNodes.query('./*') curLevelXml
			,startNodes.value('local-name(.)', 'varchar(50)') NodeName
			,startNodes.value('namespace-uri(.)', 'varchar(500)') NodeNamespaceUri
		from 
			@xaml.nodes('/*') t(startNodes) --starting with nodes under the root

		union all

		select
			 childNodes.query('./*') curLevelXml
			,childNodes.value('local-name(.)', 'varchar(50)') NodeName
			,childNodes.value('namespace-uri(.)', 'varchar(500)') NodeNamespaceUri
		from 
			walkXML 
			cross apply curLevelXml.nodes('./*') t2(childNodes) --child nodes descending down into the xml document
	)

	insert into #Output(WorkflowName, EnabledVersion, ActivityName, Occurrences)
	select @WorkflowName, @EnabledVersion, NodeName, count(1)
	from walkXML
	where 
		NodeNamespaceUri like 'clr-namespace:Cmc.Nexus.Converters%'
		or NodeNamespaceUri like 'clr-namespace:Cmc.Nexus.Workflow%'
	group by NodeName

end
close Records_Cursor;
deallocate Records_Cursor;


select * from #Output
order by WorkflowName, ActivityName