This process addresses the issue of duplicate entries in Intel® EMA that can occur when re-imaging a client that has already been provisioned.
To prevent this situation, it is advisable to unprovision the system before re-imaging. However, if the system is re-imaged without unprovisioning, duplicate entries will be created in the database, leading to potential complications.
If the endpoints were not unprovisioned before the re-imaging process, you can utilize the following script.
Note |
This is an internally developed script and is not fully tested. You may use it at your own risk. |
Back up the SQL server's databases, including the EMA database before running the script or try the process in a test environment first. Then, run the SQL script attached: Merge_Duplicate_Nodes.sql