EPO: Duplicate IP Address

Version 4

    Legend

    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.

    Purpose

    There is a query for duplicate systems but not for duplicate IP addresses. Here is a query that can be used.

     

    History

    Post any suggestions as they are always appreciated.

     

    Use

    1. Double-Click the .sql query on the db server with Management Studio (MS).
    2. Enter your credentials and select the ePO database from the upper left corner of the MS.
    3. Click Execute.

     

    Caution

    This query should be used on test or development systems. Using in production will be used at your own risk.