Over time, Archer environments and configurations may differ due to manual/unknown changes vs packaging. Instead of the stare-and-compare method, save countless hours using PowerShell scripts. The first script collects the data and the second script compares two Archer instances, finds the differences and reports other details such as extra fields or missing fields.
These scripts can be used on a regular basis to collect "snapshots" of instances for later analysis or compare against "gold" images or OOB. Another common usage is comparing development and production environments.
The attached PowerShell scripts use SQL database queries to collect details on common field settings, layouts, DDE rules and DDE actions. Because of the SQL dependency, this is not available for Hosted/SaaS customers. These scripts were demonstrated at Archer Summit 2021 in the Tool Time session.
- Find differences of field settings, layouts, DDE rules and actions
- Report on extra fields and missing fields in the source/target
- Objects are matched by Name
How to run
- At top of script file, edit the settings.
- Right-click file and select Run with PowerShell.
- When complete, a summary is displayed and saved to a CSV file.
Collect Data Settings
|exportXML||File name/path to export data to XML file. Used to compare later with other script.|
|exportZip||File name/path to zip files for copying later.|
|exportFields||File name/path to export field data to CSV file.|
|Name||Friendly name of SQL connection.|
|SqlServer||SQL Server instance name hosting the Archer database.|
|Database||SQL database name for the instance database.|
|User||Username for SQL user account. Leave blank to use Windows Authentication for connection.|
|Password||Password for SQL user account. If value is blank, user will be prompted to enter credentials.|
Compare Data Settings
|dataFile1||File name/path to XML file for instance 1 data. Leave blank to prompt user to select file.|
|dataFile2||File name/path to XML file for instance 2 data. Leave blank to prompt user to select file.|
|diffFile||File name/path to CSV file reporting differences between two instances.|
- Vote up Add ability to run System Reports using REST API. This could help collect more data for comparing.
- 1.0 - Sept 2021
NOTE: This is not an RSA supported product. Archer Support or Engineering teams will not be able to customize or enhance it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.