Try this dude....
1. Navigate to SEPM\ASA\Win32 and run dbisqlc.exe
2. That will give you a window similar to ODBC config.
3. Provide all the needed information:
Username : DBA
password: password of admin account you chose during install.
source : Symantec DSN
* In the Database tab, provide the server name as SPC_server's name (since its RU5, you have to preceeed the server's hostname by SPC_ )
* Database name is 'Sem5'
* And for database file, browse and choose sem5.db under SEPM\db\sem5.db
( Care should be taken to point to right sem5.db.... as there will be another sem5.db under asa folder)
* Click on Okay
4. If the information given are correct, it will open up a Interactive SQL.
5. In the execute window, type the following query ...For testing, lets take one of the affected client
SELECT * FROM SEM_CLIENT WHERE COMPUTER_NAME='name of the affected client'
This would give you the entries of that client in the DB ... Now, if you see more than onr entry for same client... you can delete the rest by the following query...
DELETE FROM SEM_CLIENT WHERE COMPUTER_NAME='affected computer' AND DELETED='1'
Note : Please try with one test client and lets see how it goes...