2 Replies Latest reply on Mar 8, 2016 7:20 AM by sanees

    Is there any way to find all the duplicates account created in landesk

    Apprentice

      Hi All

       

      We have two imports running and some how there are duplicates accounts getting created. We now know the reasoning as to why 2 accounts got created but we would like to figure out all the duplicates created so far so that we can delete the duplicates and ultimately have 1 account per user.

       

      Can somebody please help on this

        • 1. Re: Is there any way to find all the duplicates account created in landesk
          JulianWigman Expert

          Hi

           

          It depends on how you identify the duplicates,  if it's by the title (tps_title) field I use this. The "Name" (tps_name) and "email address" attributes are forced unique anyway so are not relevant to the testing.

           

          Ju

           

          SELECT     tps_user.tps_title AS [Name] , tps_user_type.tps_title AS [User Type]

          FROM         tps_user INNER JOIN

                                tps_user_type ON tps_user.tps_user_type_guid = tps_user_type.tps_guid

          WHERE     (tps_user.tps_title IN

                                    (SELECT     tps_title AS users

                                      FROM          tps_user AS t1

                                      WHERE      (tps_deleted = 0)

                                      GROUP BY tps_title

                                      HAVING      (COUNT(tps_title) > 1))) AND (tps_user.tps_deleted = 0)

          • 2. Re: Is there any way to find all the duplicates account created in landesk
            Apprentice

            Thanks julian

             

            I will give this a go