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

New plugin for JIRA: New Status Colors FREE

New colors for two kind of status [red] for “Cancel” or “Cancelled”, “Suspend” or “Suspended”, “Reject” or “Rejected” and [orange] for “Wait” or “Waiting”, “Hold”, “On Hold”, “Pause” or “Paused”. Only you need to create the new status using this names.(containing one of this words,i.e. for word “Waiting”: “Waiting for Customer”, “On Waiting”, …). This…

Read More