0 Replies Latest reply on Mar 22, 2013 4:12 AM by markus.pop

    How to remove a user assignment from a large number of devices

    markus.pop

      A user has changed from IT-admin department to an another department in our company.

      At the moment he is assigned to a large number of notebooks (>100)

      Do you have any idea how to remove the user-assignment without making any changes in the AD? (and if it's possible without direct SQL-DB-access)

       

      SELECT

         usr.UniqueID

        ,usr.DN

        ,leafnode.NODENAME

      FROM EPEUsers usr

      INNER JOIN EPEMACHINEUSER musr ON musr.UserID = usr.UserID

      INNER JOIN EPOLEAFNODE leafnode ON leafnode.AutoID = musr.EPOLeafNodeID

      WHERE usr.DN LIKE '%CName%'