Finds all Duplicate Devices in SCCM, sorts by creation date, and removes the oldest
Had an issue in our SCCM instnace where we were becoming incumbered with too many duplicate systems. To try and clean up the database, I ran a Query that found all duplicate items, where the names were the same, but the ResourceId was different. Foreach unique duplicate name, I sorted by the object Creation Date, found the latest, and removed the rest.