01-07-2009 08:20 AM - edited 03-10-2019 04:16 PM
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?
Solved! Go to Solution.
01-07-2009 09:05 AM
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 :
To double check things, search for references to that group. For example if it was profile 5 with the problem, search for "PROFILE
Good luck!
01-07-2009 09:05 AM
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 :
To double check things, search for references to that group. For example if it was profile 5 with the problem, search for "PROFILE
Good luck!
01-07-2009 11:46 AM
Awesome, I did as you said, found where it was indicating the wrong number of users, changed it to '0', and reloaded the dump. Everything went smoothly.
Thanks a lot.
01-07-2009 10:14 AM
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.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: