Step 1 Copy/paste the script below into any text editor and save the script as an XML file.
Step 2 Open replicationEZ and load the servers that you want to analyze for invalid ACL entries.
Step 3 From replicationEZ's Server menu, select the option 'Execute Automation File on...', select aclEZ from the list, and then select the servers you want to analyze and click 'OK'.
Step 4 Finally, find and select the XML file you just saved, and then click 'Open.'
Here is the script:
<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<ytriaAutomation Application="aclEZ" ApplicationVersion="16.5">
<!--The next line will ensure that the script will continue if an error is encountered.-->
<OnError continue="True"/>
<ExecuteListAction/>
<!--The following process will be iterated over each selected server.-->
<Select Target="Tree" Server="Click"/>
<Option Type="PresenceInNAB" Value="True"/>
<Filter columnID="NAB4" Value="Unchecked"/>
<!--Each server's results will then be exported to it's own sheet in an Excel file
saved to the same location this script file is being run from.-->
<Export>
<SetParam field="FilePath" value="{%CurFilePath%}\ServerInvalidACLAudit.xlsx"/>
<SetParam field="ExportType" value="Excel"/>
<SetParam field="Mode" value="AppendGrid"/>
<SetParam field="OpenFileOnceGenerated" value="false"/>
<SetParam field="ExcelSheetName" value="{%ListParam=server%}"/>
</Export>
<Echo value="Process Done"/>
</ytriaAutomation>