LDAP Scripted Custom Fields Uncategorized

How to create a new JIRA Scripted Custom Field obtaining LDAP attributes

Very simple! Download the plugin Kepler Custom Fields Create a SIL Script Custom Field In the custom field configuration set a new script like this: return ldapUserRecord(“attribute”, “”, “”, “”, “user@example.com”, “user”); Remember to configure the LDAP connection Go to “Cog icon” –> Addons –> KEPLER –> LDAP Configuration URL = ldap://localhost:389 BIND USER =…

Read More
Confluence tricks Uncategorized

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
JQL Uncategorized

JIRA JQL trick: Filter issues based on transition state execution date in JIRA

Very easy, see the JQL example: Project = “JIRA” AND Status CHANGED TO “In Progress” DURING (“2015/08/01″,”2015/10/05”) Other Syntax: This JQL shows all issues which have been in “Status A” for more than 14 days project=XXX and status changed to “Status A” before startofday(-14) and status = “Status A” This JQL shows all issues which…

Read More