Our company has migrated to windows 7, and the decision has been made to change all the computer names in the process. Now our database is filled with double entries for the same computer, 1 with the old computername, and 1 with the new.
The problem is, we have a lot of laptop users that are abroad, and hardly ever come into the office, so they're not migrated yet, and only have 1 entry in the database.
I want to write a query to remove the double entries, looking computers which serial number appears twice, and removing the oldest, but I don't know exactly what the "permanently remove computer" button in the console does, so i dont know how to recreate that in a query.
Thanks for your help
