Monday, June 25, 2018
How to resync Competella user database or delete multiple users
How to resync Competella user database or delete multiple users
If for instance your mapping has failed and you want to delete multiple users or resync the whole Competella database you can follow this procedure:
First login to the SQL server where the Competella database is installed.
The start a new query and run this script.
use CompetellaDatabase
declare @userid varchar(50)
declare cur CURSOR LOCAL for
select userid from [dbo].[Users] where LoginName like %
open cur
fetch next from cur into @userid
while @@FETCH_STATUS = 0 BEGIN
exec [dbo].[sp_DeleteUser] @userid
fetch next from cur into @userid
END
close cur
deallocate cur
Change the part Ive marked in blue to your Competella db-name.
Change the select Ive marked with red to match the users you want to delete.
After this is done start the Competella application suite client.
Go to process attributes on the ADImportedDistributed process and set LastTimeRunned to 2000-01-01 00:00:00
Then set the process attribute SyncOnStart to "true" and save
Then restart the ADImportedDistributed process.
Wait for the sync job to finished.
