Informed Domino Consolidation for Microsoft Migration

Want to grab the video and watch it later? Go ahead!

Whip your environment into shape with these scripts.

Throughout the webinar, you will see various scripts. We have included them below so you can apply what you learn directly to your own environment. For your convenience, comments have been included as explanations of key functionalities.

Scan all folders in a database and calculate how many documents belong to it.

This script will automatically scan for any folders and then use a formula to calculate how many documents belong to it. All findings will be reported to an Excel file. This can be run to process a single database, or multiple databases.

<ytriaAutomation Application="scanEZ" ApplicationVersion="16.5">
<!--This will set the script's behavior when encountering an error. In this case, it will continue.-->
<onerror continue="true" />
<!--The following line defines the action to take in the List named "NoteList".
	It will set values for the variables 'NoteCat' and 'NoteType'.-->
<list name="NoteList" Action="setVar" NoteCat="Designs" NoteType="Folders"/>
<!--The following Loop will be carried out in the List named "NoteList".--> 
<loop list="NoteList" OnError="Next">
	<ExecuteListAction/>
	<UnSelect Target="tree" name="All"/>
	<Select target="tree" category="{%NoteCat%}" type="{%NoteType%}"/>
	
	<!--Whatever instances found that match the category and type stated above (folder designs) will be placed into
		a virtual My Selection folder.--> 
	<MySelection>
			<Setparam Field="MySelectionName" Value="Selection of {%NoteType%}"/>
	</MySelection>
	<Focus Target="Tree" Category="Selection of {%NoteType%}"/>
	<!--If a My Selection folder is found, it will be selected, and a Values operation will be run on the designs within.
		The item $Title will be added to the Values grid, and two more columns will be added using formulas to calculate
		the database path and the number of documents within the folders found.-->
	<if Target="Tree" Test="FocusRoot" Mode="NotEquals" Value="True">
		<Values>
			<ShowTypeColumns value="false"/>
			<SetParam Target="SelectDocumentItems" Field="AddItem" value="$Title"/>
			<AddCustomColumn name="Database Path">
				<SetParam field="TitleOptionType" Value="Formula"/>
				<SetParam field="TitleOptionFormula" Value="@Implode(@DbName;&quot;!!&quot;)"/>
			</AddCustomColumn>
			<AddCustomColumn name="Number of Docs">
				<SetParam field="TitleOptionType" Value="Formula"/>
				<SetParam field="TitleOptionFormula" Value="@Elements(@DbColumn(&quot;&quot;:&quot;&quot;;@ServerName:@DbName[2];@If(@Contains($Title;&quot;|&quot;);@Left($Title;&quot;|&quot;);$Title);2))"/>
			</AddCustomColumn>
			<Evaluate/>
					<!--A report of your findings will be exported to an Excel file. The file will be found in the same
						location as where you run this script from.-->
					<Export>
						<SetParam field="FilePath" value="foldercontents.xlsx"/>
						<SetParam field="SelectedRowsOnly" value="false"/>
						<SetParam field="ExportType" value="Excel"/>
						<SetParam field="Mode" value="AppendRows"/>
						<SetParam field="ExcelSheetName" value="{%NoteType%}"/>
						<SetParam field="OpenFileOnceGenerated" value="False"/>
					</Export>
		</Values>	
	</if>
</loop> 
</ytriaAutomation> 

Find all enabled mail rules in mail files and report your findings.

This script will automatically search a mail file for enabled mail-rule documents. It will then employ formulas to display a custom list of items to explain what each mail rule does. This can be run to process a single database, or multiple databases.

<ytriaAutomation Application="scanEZ" ApplicationVersion="16.5">
	
	<!--This will set the script's behavior when encountering an error. In this case, it will continue.-->
	<onerror continue="true" />
	<!--Use the following variables to adapt the script to your own needs.-->
	<!--TO SET :: this is THE FORMULA that will be used. Note that the formula follows the general XML rules of "escaping". -->
	<SetVar vSearchFormula="SELECT Form=&quot;Mailrule&quot;&amp;Enable=&quot;1&quot;"/>
	<!--TO SET :: This is the item to use as a main "key" for the report.-->
	<SetVar vItemToUseAsKey="ActionList"/>
	<!--This script block will perform the search for the documents using the formula set earlier.-->
	<SearchBy Type="Formula">
		<Setparam Field="SetFormula" Value="{%vSearchFormula%}"/>
		<Setparam Field="SearchDocuments" Value="true"/>
		<Setparam Field="SearchDesigns" Value="false"/>
		<Setparam Field="PutSearchInSelCreateName" Value="All Enabled Mailrules"/>
	</SearchBy>
	
	<!--The following Focus line will place the focus on the newly created My Selection folder named "All Docs Found".-->
	<Focus Target="Tree" Category="All Enabled Mailrules"/>
	
	<!--The following If condition declares that If the My Selection exists (i.e. something has been found), 
		the nested child actions will be carried out.-->
	<if Target="Tree" Test="FocusRoot" Mode="NotEquals" Value="True">
		
		<!--This will set the displayed document titles to the current database name, for reference in the resulting report.-->
		<ChangeDocumentTitle>
				<Setparam Field="TitleOptionType" Value="Formula"/>
				<Setparam Field="TitleOptionFormula" Value="@Implode(@DbName;&quot;!!&quot;)"/>
		</ChangeDocumentTitle>
		
		<!-- This will enact a Diff operation on the documents within the My Selection folder and select the main "key" 
			item by the specified name.-->
		<Diff/>
		<Select target="DiffGrid" Lines="ByValue">
			<SetParam ColumnID="AI2" Value="{%vItemToUseAsKey%}"/>
		</Select>
		
		<!-- This opens the Values grid to display the values for the "key" item defined earlier.-->
		<Values>
			
			<!-- This will remove the Type column within the Values grid (for a more concise look).-->
			<ShowTypeColumns value="false"/>
			
			<!-- And this adds a custom column where the UNID will be displayed.-->
			<AddCustomColumn name="UNID">
				<SetParam field="TitleOptionType" Value="System"/>
				<SetParam field="TitleOptionSystem" Value="UNID"/>
			</AddCustomColumn>
			<Evaluate/>
			
			<!--Finally, the results of the search will be exported into a report titled report_DeleteDoc.xlsx. 
				If this script is to be executed as part of a Loop/List, the newly found information will be 
				exported and appended to the same file.-->
			<Export>
				<SetParam field="FilePath" value="report_Mailrules.xlsx"/>
				<SetParam field="SelectedRowsOnly" value="false"/>
				<SetParam field="ExportType" value="Excel"/>
				<SetParam field="Mode" value="AppendRows"/>
				<SetParam field="ExcelSheetName" value="MAILRULES FOUND"/>
				<SetParam field="OpenFileOnceGenerated" value="False"/>
			</Export>
		</Values>		
	</if>
</ytriaAutomation>

Search databases for archive profiles and report your findings .

This script will search for and analyze archive profiles process and then employ formulas to display the values for a custom set of items, obtaining helpful information regarding those profiles. The findings will then be exported to an Excel file. This can be run to process a single database, or multiple databases.

<ytriaAutomation Application="scanEZ" ApplicationVersion="16.5">
	<!--This will set the script's behavior when encountering an error. In this case, it will continue.-->
	<onerror continue="true"/>
	
	<if target="var" test="{%ListSize%}" mode="NotEquals" Value="">
		<!--This will allow the script to run if called from databaseEZ by using the option 'Execute Automation File On...'-->
		<ExecuteListAction/>
	</if>
	<!--The script uses Loop and List actions. The Loop itself can be modified to fit your needs.-->
	<!--TO SET: these variables define the profile you are looking for. 
		You may change the values to suit your needs and even add in more lines to the list keeping the format shown.
		Note: Personal profile documents are arranged in a level further down in scanEZ's selection tree and must
		be selected in a different way.-->
	<List name="allProfileName" Action="SetVar" vProfileName="archive profile"/>
	<List name="allProfileName" Action="SetVar" vProfileName="default for expired"/>
	<List name="allProfileName" Action="SetVar" vProfileName="default for last modified"/>
	<!--This line will expand the Profile Documents section of the selection tree.-->
	<Expand target="tree" Category="Profile Documents"/>
	<!--Beginning here, the rest of the script is the Loop setup. 
		All actions within this Loop section will be carried out in turn on all the lines in the List section (above)
		that use the specified name. The Loop is set to call on the List name "allProfileName".-->
	<Loop list="allProfileName" OnError="Next">
		
		<!--This next action is mandatory in order for the action within the List lines referenced to be carried out.
			In the case of the lines in the List "allProfileName", the SetVar action is to be executed.-->
		<ExecuteListAction/>
		<!--Then, everything in the tree will be deselected.-->
		<UnSelect Target="tree" name="All"/>
		
		<!--This will place the focus on the Profile Documents category so that the SelectByRegex action can be used 
			on the first-level entries within.-->
		<Focus Target="Tree" Category="Profile Documents"/>
		
		<!--The following line will enact a regex search on the first-level profile documents to find any profile 
			documents that contain the name provided.-->
		<SelectByRegex Regex="{%vProfileName%}"/>
		
		<!--As stated early on in this script, Personal Profile documents are arranged at a deeper level in the
			selection tree. If you want to be able to search through both of these levels at the same time to find
			both the first level profile documents and personal profile documents with this name use this line in place
			of the regex search above <Select Target="Tree" Category="Profile Documents" Type="{%vProfileName%}"/> -->
		
		<!--This will create a new My Selection folder containing the found documents. 
			By doing this the displayed titles can be set to your desired form (titles cannot be set within the
			Profile Documents category).-->
		<MySelection>
			<Setparam Field="MySelectionName" Value="Selection of {%vProfileName%}"/>
			<Setparam Field="TitleOptionType" Value="Formula"/>
			<Setparam Field="TitleOptionFormula" Value="@Implode(@DbName;&quot;!!&quot;)"/>	
		</MySelection>
		<!--Then the focus is placed on the newly created My Selection folder.-->
		<Focus Target="Tree" Category="Selection of {%vProfileName%}"/>
		
		<!--The following If condition declares that if the My Selection does exist,
			(meaning that something has been found) the nested child actions will be enacted.-->
		<if Target="Tree" Test="FocusRoot" Mode="NotEquals" Value="True">
			
			<!--A Values function is carried out on the focused My Selection folder.-->
			<Values>
				
				<!--All items within the Values grid are selected.-->
				<SetParam Target="SelectDocumentItems" Field="All" value="true"/>
				
				<!--And finally all the findings are exported to an Excel file; the results for each profile name 
					will be placed on its own sheet within the file. The file will be saved in the same location 
					as the this Automation file.-->
				<Export>
					<SetParam field="FilePath" value="archivereport.xlsx"/>
					<SetParam field="SelectedRowsOnly" value="false"/>
					<SetParam field="ExportType" value="Excel"/>
					<SetParam field="Mode" value="AppendRows"/>
					<SetParam field="ExcelSheetName" value="{%vProfileName%}"/>
					<SetParam field="OpenFileOnceGenerated" value="False"/>
				</Export>
			</Values>
			
		</if>
		
	</Loop>
</ytriaAutomation>
	

Search for ALL mail-related profiles and report your findings.

This script will automatically search for all mail-related profiles (such as archive profiles, calendar profile, etc.) and then export all their information to an Excel file. This can be run to process a single database, or multiple databases.

<ytriaAutomation Application="scanEZ" ApplicationVersion="16.5">
	<!--This will set the script's behavior when encountering an error. In this case, it will continue.-->
	<onerror continue="true"/>
	
	<if target="var" test="{%ListSize%}" mode="NotEquals" Value="">
		<!--This will allow the script to run if called from databaseEZ by using the option 'Execute Automation File On...'-->
		<ExecuteListAction/>
	</if>
	<!--The script uses Loop and List actions. The Loop itself can be modified to fit your needs.-->
	<!--TO SET: these variables define the profile you are looking for. 
		You may change the values to suit your needs and even add in more lines to the list keeping the format shown.
		Note: Personal profile documents are arranged in a level further down in scanEZ's selection tree and must
		be selected in a different way.-->
	<List name="allProfileName" Action="SetVar" vProfileName="CalendarProfile"/>
	<List name="allProfileName" Action="SetVar" vProfileName="archive  profile"/>
	<List name="allProfileName" Action="SetVar" vProfileName="archive database profile"/>
	<List name="allProfileName" Action="SetVar" vProfileName="default for last modified"/>
	<List name="allProfileName" Action="SetVar" vProfileName="default for expired"/>
	<!--This line will expand the Profile Documents section of the selection tree.-->
	<Expand target="tree" Category="Profile Documents"/>
	<!--Beginning here, the rest of the script is the Loop setup. 
		All actions within this Loop section will be carried out in turn on all the lines in the List section (above)
		that use the specified name. The Loop is set to call on the List name "allProfileName".-->
	<Loop list="allProfileName" OnError="Next">
		
		<!--This next action is mandatory in order for the action within the List lines referenced to be carried out.
			In the case of the lines in the List "allProfileName", the SetVar action is to be executed.-->
		<ExecuteListAction/>
		<!--Then, everything in the tree will be deselected.-->
		<UnSelect Target="tree" name="All"/>
		
		<!--This will place the focus on the Profile Documents category so that the SelectByRegex action can be used 
			on the first-level entries within.-->
		<Focus Target="Tree" Category="Profile Documents"/>
		
		<!--The following line will enact a regex search on the first-level profile documents to find any profile 
			documents that contain the name provided.-->
		<SelectByRegex Regex="{%vProfileName%}"/>
		
		<!--As stated early on in this script, Personal Profile documents are arranged at a deeper level in the
			selection tree. If you want to be able to search through both of these levels at the same time to find
			both the first level profile documents and personal profile documents with this name use this line in place
			of the regex search above <Select Target="Tree" Category="Profile Documents" Type="{%vProfileName%}"/> -->
		
		<!--This will create a new My Selection folder containing the found documents. 
			By doing this the displayed titles can be set to your desired form (titles cannot be set within the
			Profile Documents category).-->
		<MySelection>
			<Setparam Field="MySelectionName" Value="Selection of {%vProfileName%}"/>
			<Setparam Field="TitleOptionType" Value="Formula"/>
			<Setparam Field="TitleOptionFormula" Value="@Implode(@DbName;&quot;!!&quot;)"/>	
		</MySelection>
		<!--Then the focus is placed on the newly created My Selection folder.-->
		<Focus Target="Tree" Category="Selection of {%vProfileName%}"/>
		
		<!--The following If condition declares that if the My Selection does exist,
			(meaning that something has been found) the nested child actions will be enacted.-->
		<if Target="Tree" Test="FocusRoot" Mode="NotEquals" Value="True">
			
			<!--A Values function is carried out on the focused My Selection folder.-->
			<Values>
				
				<!--All items within the Values grid are selected.-->
				<SetParam Target="SelectDocumentItems" Field="All" value="true"/>
				
				<!--And finally all the findings are exported to an Excel file; the results for each profile name 
					will be placed on its own sheet within the file. The file will be saved in the same location 
					as the this Automation file.-->
				<Export>
					<SetParam field="FilePath" value="scanEZ_Profiles_Report.xlsx"/>
					<SetParam field="SelectedRowsOnly" value="false"/>
					<SetParam field="ExportType" value="Excel"/>
					<SetParam field="Mode" value="AppendRows"/>
					<SetParam field="ExcelSheetName" value="{%vProfileName%}"/>
					<SetParam field="OpenFileOnceGenerated" value="False"/>
				</Export>
			</Values>
			
		</if>
		
	</Loop>
</ytriaAutomation>
	

Scan a database for any forms and subforms and report your findings.

This script will automatically search for any forms and subforms, display a selection of information related to these designs, and then export all the information into an Excel file. This can be run to process a single database, or multiple databases.

<ytriaAutomation Application="scanEZ" ApplicationVersion="16.5">
<!--This will set the script's behavior when encountering an error. In this case, it will continue.-->
<onerror continue="true" />
<!--The following lines define the Action to take, and thus the variables to set. This will happen in two
	batches. The first line sets one set of variables, the second sets another. This allows the Loop to concentrate
	on one line at a time.-->
<list name="NoteList" Action="setVar" NoteCat="Designs" NoteType="Forms"/>
<list name="NoteList" Action="setVar" NoteCat="Designs" NoteType="SubForms"/>
<!--The following Loop, will iterate over the lines of the List set above. As each set of variables is set
	the Loop will then select the tree nodes in the design tree that match the conditions.--> 
<loop list="NoteList" OnError="Next">
	<ExecuteListAction/>
	<UnSelect Target="tree" name="All"/>
	<Select target="tree" category="{%NoteCat%}" type="{%NoteType%}"/>
	
	<!--Anything that is selected in the tree will then be placed into virtual My Selection folders for further processing.--> 
	<MySelection>
			<Setparam Field="MySelectionName" Value="Selection of {%NoteType%}"/>
	</MySelection>
	<!--If a My Selection is created, it will be selected.-->
	<Focus Target="Tree" Category="Selection of {%NoteType%}"/>
	<if Target="Tree" Test="FocusRoot" Mode="NotEquals" Value="True">
		<!--The following block will enact a Values operation on contents of the My Selection folder. The item $Title will be added
			as will five additional columns that will display database path, the number of fields, a list of fields, and a list of any
			subforms.-->
		<Values>
			<ShowTypeColumns value="false"/>
			<SetParam Target="SelectDocumentItems" Field="AddItem" value="$Title"/>
			<AddCustomColumn name="Database Path">
				<SetParam field="TitleOptionType" Value="Formula"/>
				<SetParam field="TitleOptionFormula" Value="@Implode(@DbName;&quot;!!&quot;)"/>
			</AddCustomColumn>
			<AddCustomColumn name="Number of Fields">
				<SetParam field="TitleOptionType" Value="Formula"/>
				<SetParam field="TitleOptionFormula" Value="@Elements($Fields)"/>
			</AddCustomColumn>
			<AddCustomColumn name="Number of Subforms">
				<SetParam field="TitleOptionType" Value="Formula"/>
				<SetParam field="TitleOptionFormula" Value="@Elements($Subforms)"/>
			</AddCustomColumn>
			<AddCustomColumn name="List of fields">
				<SetParam field="TitleOptionType" Value="Formula"/>
				<SetParam field="TitleOptionFormula" Value="@Implode($Fields;&quot;, &quot;)"/>
			</AddCustomColumn>
			<AddCustomColumn name="List of subforms if any">
				<SetParam field="TitleOptionType" Value="Formula"/>
				<SetParam field="TitleOptionFormula" Value="@Implode($Subforms;&quot;, &quot;)"/>
			</AddCustomColumn>
			<Evaluate/>
					<!--Any findings will be exported to an Excel file. The findings for each of the two different note 
						types (forms and subforms) will be placed in a separate worksheet within the same file.-->
					<Export>
						<SetParam field="FilePath" value="formssubforms.xlsx"/>
						<SetParam field="SelectedRowsOnly" value="false"/>
						<SetParam field="ExportType" value="Excel"/>
						<SetParam field="Mode" value="AppendRows"/>
						<SetParam field="ExcelSheetName" value="{%NoteType%}"/>
						<SetParam field="OpenFileOnceGenerated" value="False"/>
					</Export>
		</Values>	
	</if>
</loop> 
</ytriaAutomation> 
	

Scan mail files for any encrypted emails.

This script will automatically scan mail files for any encrypted emails, display information about these documents (such as their UNID and database path), and export the findings into one Excel file with each type of encryption scenario on its own worksheet. This can be run to process a single database, or multiple databases.

<ytriaAutomation Application="scanEZ" ApplicationVersion="16.5">
<!--This line will set the script's behavior when encountering an error. In this case, it will continue.-->
<onerror continue="true"/>
<!--The following List is named 'TreeOptions'. It defines the Document Analyzer categories that will be checked.-->
<list name="TreeOptions" Action="setVar" Option="CategoryEncryptionSecret"/>
<list name="TreeOptions" Action="setVar" Option="CategoryEncryptionPublicListed"/>
<list name="TreeOptions" Action="setVar" Option="CategoryEncryptionPublicUnListed"/>
<!--The following Loop will iterate over all lines in the List 'TreeOptions'. If an error is encountered,
  the process will move on to next line in the List. For each line the Document Analyzer will process
  documents only using the criteria set in the variable of the corresponding List line. A set of If 
  tests will be carried out to check if data has been found in the Document Analyzer.-->
<loop list="TreeOptions" OnError="Next">
  <ExecuteListAction/>
  <echo value="#### {%Option%}"/>
<!--The following variable, 'hasData', is set to 'no' as a base condition against which a 
  quantity of data found can be compared to.-->
  <setvar hasData="no"/>
  <DocumentAnalyzer KeepAlive="false">
    <SetParam field="DesignElements" value="false"/>
    <SetParam field="Documents" value="true"/>
    <SetParam field="TreeOptions" value="{%Option%}"/>    
    <Select Lines="All"/>
<!--Here, an If condition will test to see if anything has been found in the Document Analyzer search.
  If any data has been found, the visible row count will be more than 0, and thus the variable 'hasData'
  will be set to 'yes' for later use. All documents found will be placed in a virtual My Selection folder.-->
    <if target="DocAnalyzerGrid" test="VisibleRowsCount" Mode="NotEquals" Value="0">
      <setvar hasData="yes"/>
      <MySelection>
        <Setparam Field="MySelectionName" Value="Selection of {%Option%}"/>
        <Setparam Field="TitleOptionType" Value="Formula"/>
        <Setparam Field="TitleOptionFormula" Value="&quot;{%Option%}&quot;"/>
      </MySelection>
    </if>
  </DocumentAnalyzer>
<!--The following If condition states that if the variable 'hasData' equals 'yes', data has been found
  and thus the following processes can be carried out. If it has not been set to "yes", there will be
  no attempt at processing.--> 
  <if target="var" test="{%hasData%}" mode="equals" value="yes">
    <Select target="Tree" Category="Selection of {%Option%}"/>
    <Focus target="Tree" Category="Selection of {%Option%}"/>
    <echo value="**** {%Option%}"/>
<!--Here, a Values operation will be carried out on the focused My Selection folder. Values for 
  the Subject field, Database Path, and UNID will be added to the grid. All of this information will
  be then exported to an Excel file where each type of encryption status infomation will be reported 
  on a separate page. The report will be saved in the same location as this XML file.-->
    <Values>
      <ShowTypeColumns value="false"/>
      <SetParam Target="SelectDocumentItems" Field="AddItem" value="Subject"/>
        <AddCustomColumn name="Database Path">
          <SetParam field="TitleOptionType" Value="Formula"/>
          <SetParam field="TitleOptionFormula" Value="@Implode(@DbName;&quot;!!&quot;)"/>
        </AddCustomColumn>
        <AddCustomColumn name="Document UNID"> 
          <SetParam field="TitleOptionType" Value="System"/> 
          <SetParam field="TitleOptionSystem" Value="UNID"/> 
        </AddCustomColumn>
        <Evaluate/>
          <Export>
            <SetParam field="FilePath" value="EncryptedMails.xlsx"/>
            <SetParam field="SelectedRowsOnly" value="false"/>
            <SetParam field="ExportType" value="Excel"/>
            <SetParam field="Mode" value="AppendRows"/>
            <SetParam field="ExcelSheetName" value="{%Option%}"/>
            <SetParam field="OpenFileOnceGenerated" value="False"/>
          </Export>
      </Values> 
  </if>  
</loop> 
</ytriaAutomation>
	

Time-Stamped Outline