New JIRA Cloud development environment FREE!

Info extracted from: “https://developer.atlassian.com/blog/2016/04/cloud-ecosystem-dev-env/?utm_source=newsletter&utm_medium=email&utm_campaign=developer-newsletter_may-2016” Cloud development instances “In order to make the cloud development experience better, we have designed a new environment for you that includes free development instances exclusively for add-on developers. When you sign up for a developer instance, you will get: JIRA Core: 5 users free JIRA Software: 5 users free Confluence:…

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