1 = Obtains data from SQL. No changes to the database are performed.
2 = Data will be modified (Backup your database)
3 = Data will be deleted\removed (Backup your database)
Query Rating: 1 - Obtains data from SQL. No changes to the database are performed.
There is a query for duplicate systems but not for duplicate IP addresses. Here is a query that can be used.
Post any suggestions as they are always appreciated.
- Double-Click the .sql query on the db server with Management Studio (MS).
- Enter your credentials and select the ePO database from the upper left corner of the MS.
- Click Execute.
This query should be used on test or development systems. Using in production will be used at your own risk.