cancel
Showing results for 
Search instead for 
Did you mean: 
markus.pop
Level 7

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

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%'

0 Kudos