How to remove Jira customfields in bulk with a Groovy script

IMPORTANT NOTE: This script removes permanently a subset of customfields of your Jira. Before launch this script, we STRONGLY recommend to create a backup (following the Atlassian instructions). MrAddon is not responsible of the bad use of this script, the data removed, or some consequence derived. This script removes permanently the Jira customfields that start…

Read More

Obtaining Confluence metrics & SQL tricks

MySQL query to get the last login of all members of the confluence-users group SELECT distinct u.lower_user_name, l.successdate FROM cwd_user u LEFT JOIN logininfo l ON u.user_name = l.username JOIN cwd_membership m ON u.id = m.child_user_id JOIN cwd_group g ON m.parent_id = g.id JOIN spacepermissions sp ON g.group_name = sp.permgroupname WHERE permtype=’USECONFLUENCE’ order by u.lower_user_name; …

Read More