As long as those users are not available on Automation Engine, we can use ImportExport CLI to delete those user from ARA schema.
For detailed instruction, please find in the example below:
- First do a CLI EXPORT command to retrieve XML format output file (this step is similar to doing a select query)
ImportExportCLI.exe export -con http://localhost:80/CDA -usr 1/CDA/AUTOMIC -pwd *** -mt user -format XML -fi user_output.xml -where "system_name eq '25/MORLGO3_RM/UC4'"
- The output XML can be used to guide DELETE command, but in order to do so, you have to remove all other properties but system_name which can be used as a sole identifier. See example:
<?xml version="1.0" encoding="utf-8"?>
<Sync xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="sync.xsd">
<Entity mainType="User">
<Property name="system_name" isIdentity="true">
<Value>25/MORLGO3_RM/UC4</Value>
</Property>
</Entity>
</Sync>
- Then do a CLI DELETE command to perform a deletion of the selected user: e.g (simply replace "export" by "delete"):
ImportExportCLI.exe delete -con http://localhost:80/CDA -usr 1/CDA/AUTOMIC -pwd *** -mt user -format XML -fi user_output.xml -where "system_name eq '25/MORLGO3_RM/UC4'"
- Lastly please check the Member table and see if it was successfully removed.