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.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide