4 Replies Latest reply on Mar 16, 2009 1:49 PM by medriver

    How to find duplicate devices in a large inventory?

    Apprentice

      Hello,

       

      I recently notice in my event viewer that I am getting references regarding some duplicate devices and I would like to get this cleaned up.

       

      Inventory server detected {5F043037-DE8F-AD44-9FB9-EFE02374E322} as a duplicated device ID.

       

      Currenty I have 5000+ clients and it has become a challenge for me to easily identify these duplicates. Is there and easy way to scan for these to help me get this cleaned up?

       

      Thanks,

       

      Mike

       

        • 2. Re: How to find duplicate devices in a large inventory?
          zman Master

          Not as full featured or elegant as Jack's- SQL

           

          Select Computer.DEVICENAME, count(*) from computer group by
          DEVICENAME having count (*) <> 1
          
          • 3. Re: How to find duplicate devices in a large inventory?
            SupportEmployee

            I really all depends on how your duplicates are showing up.  If you have clients getting new device ids (such as reinstalling the client after deleting the appropriate data), then you will see the same device name showing up more than once.  If you are reimaging machines, then the device name is likely going to be different and so you need to use different attributes, such as the MAC address (although there can be valid duplicates, such as VPNed machines) or serial number (as long as the serial number actually gets put in the bios).

             

            To really find the duplicates you need to do more than just look at device names, although in most instances that will get a high percentage of duplicates, depending on how the duplicates are getting in.

            • 4. Re: How to find duplicate devices in a large inventory?
              Apprentice

              Thanks guys, Most of our duplicate devices are being created when replacing an existing device that has failed. When a POS workstation fails in the field it is replaced using the same name. We do have proceedures for removing devices from the DB before provisioning a new system but as we all know, people don't always follow the proceedures as prescribed. Usually I find quite a few of the duplicates by sorting on the last hardware scan date. Most of the time, duplicates (old systems) show up having a old scan date as they no longer update the DB. I will then sort by the device name and sure enough, I will have two of them which at that point I remove the old one.

               

              Thanks,

               

              Mike