Notification

Icon
Error

Delete old AD-Users in non existing Domain

Posted: Tuesday, March 12, 2019 5:40:12 PM(UTC)
BastiOn

BastiOn

Member Original PosterPosts: 14
1
Like
Hy,

we have severel hundred users from a defunct domain. The users have been migrated to our active Domain.
Unfortunately the users wasn't delete in Lansweeper. Under "Active Directory Users OU" the domain and the users still stand.

How can i delete all users with SQL Command? I do not want to try this on the livesystem

Thanks
BastiOn

natebraun1
#1natebraun1 Member Posts: 6  
posted: 3/13/2019 3:34:54 PM(UTC)
Hello,

I have the same issue. We went through a merger last year and had two domains being scanned. Now, all users have been migrated, and we are left seeing duplicate users. Is there a bulk delete for users in the same way as assets?

Thank you,

Nate
natebraun1
#2natebraun1 Member Posts: 6  
posted: 3/14/2019 4:23:35 PM(UTC)
So, I went into SQL Server Manager and ran the following simple query.
Substitute your domain name for OLD_DOMAIN_NAME.

I got rid of them all real quick. Hit F5 on my browser, and they were gone.



Delete [lansweeperdb].[dbo].[tblADusers]
WHERE [Userdomain] = 'OLD_DOMAIN_NAME'
BastiOn
#3BastiOn Member Original PosterPosts: 14  
posted: 3/14/2019 6:10:03 PM(UTC)
Hy natebraun1

it works very nice Angel

thx

Active Discussions

Lansweeper Remove all users from old domain
by  cmuter   Go to last post Go to first unread
Last post: 9/20/2019 8:03:58 PM(UTC)
Lansweeper Static IP Address
by  cycleheat  
Go to last post Go to first unread
Last post: 9/20/2019 4:07:16 PM(UTC)
Lansweeper Bitlocker Encryption Recovery Key no information found
by  Stephane   Go to last post Go to first unread
Last post: 9/20/2019 2:26:19 PM(UTC)
Lansweeper InTune Scanning Issues
by  Esben.D  
Go to last post Go to first unread
Last post: 9/20/2019 12:34:59 PM(UTC)
Lansweeper Office 365 scanning issues
by  Esben.D   Go to last post Go to first unread
Last post: 9/20/2019 12:23:30 PM(UTC)
Lansweeper Hard Drive Tracking - Start to Finish
by  Lone Jedi  
Go to last post Go to first unread
Last post: 9/19/2019 8:11:56 PM(UTC)
Lansweeper Lansweeper Reporting Old Assets as New
by  Jpatterson   Go to last post Go to first unread
Last post: 9/19/2019 12:52:14 PM(UTC)
Lansweeper Cannot edit a ticket anymore
by  Esben.D  
Go to last post Go to first unread
Last post: 9/19/2019 12:32:42 PM(UTC)