![www.MrAddon.com ®: Jira & Confluence Administration Support Blog & Ethereum Dev Blog – [www.MrAddon.blog] ®](https://jirasupport.files.wordpress.com/2022/09/cropped-logo-mr-addon-vertical-1.png){kind=logo}
jira confluence admin administration support script scriptrunner groovy mraddon barcelona plugin custom development it technology barcelonatech ethereum development
Sometimes we just have to dig through the Jira Server or Datacenter database to find what we’re looking for. In this case, we want to know the old references of the moved tickets and extract a list. How do we do it? We will query the database as there is no other way through the…
Read More
Here a list of useful commands to do installations of Atlassian tools in MySQL Example for CentOS with yum ( install of MySQL client) At the command line of your instance, install wget: sudo yum -y install wget Install the MySQL client on the instance: sudo yum -y install mysql Download MySQL Connector/J Jira connects to…
Read More
In large companies, there are usually a large number of projects of which, most of them are currently inoperative. Therefore, from MrAddon we advise you to execute this query every year and list all those projects that since a certain date have not updated their tickets. The list includes the name and the key of…
Read More
We have talked about the Servlet extraction of worklogs: How to extract an Excel report from Tempo Timesheets using an URL We have talked also about the Tempo API REST worklog extraction using groovy: How to list your Jira Tempo Teams and members in a Confluence page Jira Groovy example script to get Tempo Teams…
Read More
To set up Atlassian Jira on Amazon EC2 we can follow this fantastic post: See here. (It’s a little bit outdated the previous link, but you can complement with the below list) MySQL useful links: How to find out the MySQL root password Download latest Jira Software binary file Installing Jira on Linux How to Check…
Read More
In this example, we want to explain how we can create a Heatmap (Worldmap) using eazyBI (in this case for Jira). As prerequisite we need a CSV with at least 3 fields: one for the ID of the row and other two fields for the longitude and geographical latitude. We need a special dimension for the…
Read More
Imagine you want to change the name or the classification of the project “categories” in your JIRA projects… or names of customfields…. Then, a lot of JQL queries and filters will fail… ¿How we can change the JQL sentences in mode massive of all filters of JIRA? The only solution is making the change in…
Read MoreMySQL 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
Our recommended books:
 |
 |
 |
 |
 |
www.MrAddon.com ®: Jira & Confluence Administration Support Blog & Ethereum Dev Blog - [www.MrAddon.blog] ® 