What I need to do in atlassian when rename Active directory groups ?

Question

Hi there,

I will rename Active directory user groups. Some of them are used in atlassian like JIRA and confluence sharing etc. What will be in Atlassian ? Does atlassian use SID or group names ? When I change name of groups, what i need to do in JIRA and confluence ?

Daniel Eads {unmonitored account} · Answer

Here are some SQL queries to help you track down which JIRA Projects a group might be used in (Oracle syntax, you might need to tweak the quotes for use in MySQL/PostGRE) -

select pkey, roletypeparameter from projectroleactor
join project on projectroleactor.pid = project.id
where projectroleactor.ROLETYPEPARAMETER = 'AD_GROUP_NAME'

Hopefully, if you're using project roles well, that first query is the only one you'll need. However, we have some legacy projects on our JIRA instance where somebody added a group (instead of a Project Role) on the notification and permission schemes, which makes these queries really useful:

select notif_type, notif_parameter, name from notification
join notificationscheme on notification.scheme = notificationscheme.ID
where notif_parameter = 'AD_GROUP_NAME'

select perm_parameter, permission_key, name from schemepermissions
join permissionscheme on schemepermissions.scheme = permissionscheme.id
where perm_parameter = 'AD_GROUP_NAME'

ortadoguenerji · Answer

Ok, thanks for your collaboration.

Tim Eddelbüttel · Answer

I mean if you are also the active directory administrator then you know when groups are renamed and you can plan the change. That's what i mean.