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.



visit link download