Now Jirasupport is MrAddon!

Good morning Jira addicts! 🙂 It’s an enormous pleasure for me to present my new company based on Barcelona, called MrAddon. In this company, we will provide IT solutions based in the main Atlassian components and services like JIRA, Confluence, Bitbucket, HipChat, Crowd,etc. and the most famous JIRA plugins like Tempo Timesheets,  Adaptavist ScriptRunner, Moresimp…

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