'Ghost' ACS Users

Answered Question

I'm in the process of cleaning up our ACS DB, by using csutil -i and deleting users. I have one group that says "Group 98(29 Users)", but when I click the 'users in group' button on the group setup screen there are no users displayed, and if I use csutil -u to dump the list of users, it lists Group 98 but with no users under it.


I also have tried compact the database twice using csutil -q -d -n -l , and have had no luck.


Has anyone seen this or do you have any ideas on how I can delete these users that don't seem to be there?

Correct Answer by darpotter about 8 years 2 months ago

Make sure you backup the db first... then try this.


Edit the dump.txt and locate the groups with wrong number of users. Each group has a ###PROFILEN record (where N is 0 to 500).


The default group is profile 0 and so on.


You'll see a "User Count : " which should be a zero for groups with no users.


To double check things, search for references to that group. For example if it was profile 5 with the problem, search for "PROFILE: 5". This will find any users (shouldnt be any) that think they are still assigned to that group. is actually the TAB control character - csutil uses tabs as delimiters.


Good luck!


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Correct Answer
darpotter Wed, 01/07/2009 - 09:05
User Badges:
  • Silver, 250 points or more

Make sure you backup the db first... then try this.


Edit the dump.txt and locate the groups with wrong number of users. Each group has a ###PROFILEN record (where N is 0 to 500).


The default group is profile 0 and so on.


You'll see a "User Count : " which should be a zero for groups with no users.


To double check things, search for references to that group. For example if it was profile 5 with the problem, search for "PROFILE: 5". This will find any users (shouldnt be any) that think they are still assigned to that group. is actually the TAB control character - csutil uses tabs as delimiters.


Good luck!


jhillend Wed, 01/07/2009 - 10:14
User Badges:
  • Bronze, 100 points or more

The "csutil -q -d -n -l" call should have cleaned it up. Some have performed a full backup followed immediately by a full restore and that has helped. I recommend that you contact the TAC. They have some tools that might help.

Actions

This Discussion