Deleting record from ICM User_Group table

Unanswered Question
Oct 23rd, 2007
User Badges:
  • Bronze, 100 points or more


I've disassociated agent supervisor login from an AD user, and when Agent Explorer asks me to delete AD user I said NO. Now, I want to associate a new Agent to AD user and Agent explorer says that this user is actually associate to a supervisor or is an ICM User.

How can I delete the old record from User_Group table?

Thanks in advance and best regards.


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
david.macias Tue, 10/23/2007 - 06:45
User Badges:
  • Blue, 1500 points or more

Does this user come up in the person list in configuration manager? if they do show up there, you can delete them through there.


antonio.vazquez Tue, 10/23/2007 - 07:10
User Badges:
  • Bronze, 100 points or more

Hi David,

from Person List, how can I delete that record?

I don't find where in Person List I can assigned a AD user.

Thanks for your help.

Best Regards

antonio.vazquez Tue, 10/23/2007 - 07:23
User Badges:
  • Bronze, 100 points or more


I have seen User_Group,User_Group_Member, User_Supervisor_Map and t_Agent and the agent associated in first three tables doesn't exist in t_Agent table.

So, How could I delete orphan records in User_Group, User_Group_Member and User_Supervisor_Map to reuse AD user with a new agent supervisor?


Abdulbaseer Mohammed Tue, 10/23/2007 - 13:15
User Badges:
  • Silver, 250 points or more


To remove the deleted objects in Configuration Administration go to :


configuration/Administration/deleted objects

when you remove and refresh you should be fine.

if it helps please rate.

antonio.vazquez Tue, 10/23/2007 - 22:10
User Badges:
  • Bronze, 100 points or more


I cannot remove this records from deleted objects in ICM Configuration Manager. My problem is that the agent whose is using AD user have been deleted and the relation still keep in User_Group,User_Group_Member and User_Supervisor_Map.

Any ideas?

Thanks for all

jeff.marshall Wed, 10/24/2007 - 12:22
User Badges:

First make sure that everthing is working correctly. What you describe isn't necessarily the way it's supposed to function.

I've been sucessful with going into SQL directly and removing orhphaned records in those tables that you describe. As always, backup your configuration (use ICMDBA on the Logger and export the configuration to a folder) then make the change and test. Any faults can be recovered by this backup.



This Discussion