Process step to resolve duplicate entries within databases
- Unable to make existing endpoints recognized in the Intel® Endpoint Management Assistant (Intel® EMA) console, after operating system (OS) is re-imaged in endpoint
- Unable to make the duplicate endpoints entries to consolidate after the endpoint is been re-imaged
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