Number of Groups in my Database Statistics far exceeds the actual number

[Gary Pasquale]

Hi,

When checking my Database Statistics (System>System info>Database Statistics) the number of groups shown is 1076.

The actual number of groups I can see under the group section (User Managment>Groups) is 141

Anybody know why there would be such a difference?

Maybe when a group is deleted via the UI it remains in the DB statistics?

Regards,

Gary

[Andy Heinzer · Accepted solution]

Hi Gary,

I too can't see the post on this thread I had earlier,  that is very strange.  When I logout of our site and return to this page, I CAN see my previous post.  I am raising this problem with my own support team to better investigate what might cause this behavior.  In the meantime here is a quote of my previous reply:

It looks like you have at least 8 user directories in Jira (1 internal, 7 external).  You might have more, I can't say for sure from just that one screenshot, but you have at least that many.

If you added the same user directory to Jira 7 times, and it is syncing the same user groups, each directory have their own groups.   Since 7 * 141 =987 I would venture a guess that this accounts for the vast majority of all the groups that are being counted in the database.

I'm not sure why you would have a configuration like this, but it is possible.  Perhaps each user directory is using a slightly different ldap filter in order to limit the number of users/groups returned by that specific user directory.  

And from seeing your most recent reply you do have much more than 8 user directories in Jira.   This explains why you are likely seeing duplicate record entries in the database for the groups.   But I wouldn't be too worried that you see these entries in the database.

Please let me know if you have any additional concerns here.

Andy

[Gary Pasquale]

@Andy Heinzer - Ok, thanks for your help.

[Andy Heinzer]

It's difficult to say with just that information.  What you could do if you have access to the SQL database, would be to run a SQL command such as

select * from cwd_group;

This will return to you all the groups listed in the Jira database.   I would suspect that you have connected Jira to one or more external user directories.  In turn these can also bring in users and groups.   Perhaps if you disabled a user directory in Jira, the groups could still exist in the database, but not appear to you as groups that could be managed from within Jira.

Each record returned from that query will have at least two fields of interest: 'active' and 'directory_id'.  If the directory is active, it will have a value of 1.  The directory_id value will correspond to the user directory where that group comes from (where 1 is the Jira internal user directory, and the others can be found in the cwd_directory table.)

[Gary Pasquale]

Hi @Andy Heinzer,

Thanks for your response.

Our instance is connected to active directory, but we only use it for authentication. All groups and users are stored locally.

After running your SQL, I can see that the same groups are listed multiple times. Often 2 or 3 times but in some cases as many as 19 times. below is an example or a group that has 8 entries.

What could be causing this behaviour?

Regards,

Gary

[Andy Heinzer]

It looks like you have at least 8 user directories in Jira (1 internal, 7 external).  You might have more, I can't say for sure from just that one screenshot, but you have at least that many.

If you added the same user directory to Jira 7 times, and it is syncing the same user groups, each directory have their own groups.   Since 7 * 141 =987 I would venture a guess that this accounts for the vast majority of all the groups that are being counted in the database.

I'm not sure why you would have a configuration like this, but it is possible.  Perhaps each user directory is using a slightly different ldap filter in order to limit the number of users/groups returned by that specific user directory.  

[Gary Pasquale]

Hi @Andy Heinzer,

I think your last response is missing from this ticket?

I was going to respond to say we have a number of user directories that point to different OU's in Active Directory.

Is this a factor?

Regards,

Gary