The first columns have machine names and the second column is the user who owns that machines
I would like to run a query that deletes all the dups...keeping only one of them.
So if you have four machine names and four of the same user names. I want it to find all the machine names and delete all except for one.
How do I do that?
I did a query wizard "find match" but it wont keep one of each.