JIRA - find a plugin usage in a Workflow (groovy Script Runner + SQL version)

 Know where/if  a plugin is used. Both have to be adapted to match a specific plugin.

First version gives more data but requires ScriptRunner.

Second version only uses SQL, but is less extensive.

You need to know what you're looking for : com.innovalog.jmwe.jira-misc-workflow-extensions

Script Groovy

Adapted from :  https://answers.atlassian.com/questions/205094/how-to-find-all-workflows-which-are-using-postfunctions-of-a-plugin

import com.atlassian.jira.component.ComponentAccessor import com.atlassian.jira.workflow.JiraWorkflow import com.atlassian.jira.workflow.WorkflowManager import java.util.regex.Matcher    String searchText = 'com.innovalog.jmwe.jira-misc-workflow-extensions'    WorkflowManager workflowManager = ComponentAccessor.getWorkflowManager() Collection<JiraWorkflow> workflows = workflowManager.getWorkflows()    String result = "Workflow;Function;Type;Action;Step\r\n<br/>"    workflows.each{workflow ->     def workflowXml = workflow.descriptor.asXML()     Matcher m = workflowXml =~ /${searchText}/     if (m.find()) {         String workflow_name = "${workflow.name}${if(!workflow.isActive()){";(inactive)"} else ';active'}${if(workflow.isDraftWorkflow()){"(draft)"} else ''}"         def wf = new XmlParser().parseText(workflowXml)         List<Node> wf_flat = wf.depthFirst()         wf_flat.each{             if (it.text() ==~ /.*${searchText}.*/){                 result += "$workflow_name;${getNodeInfo(it,searchText)}\n\n<br/>"             }         }     } } result    String getNodeInfo(Node n, String search) {     String nodetext = ''     nodetext += "${n.text() - search}"     def p = n.parent()     while (p) {         switch (p.name()) {             case '"post-functions"':                 nodetext += ";post-function "; break             case 'validators':                 nodetext += ";validator "; break             case 'conditions':                 nodetext += ";condition "; break             case 'action':                 nodetext += ";${p.attribute('name')} (${p.attribute('id')})"; break             case 'step':                 nodetext += ";${p.attribute('name')} (${p.attribute('id')})"; break             case 'global-actions':                 nodetext += ";GLOBAL "; break             case 'initial-actions':                 nodetext += ";INITIAL "; break            }         p = p.parent()     }     return nodetext }

 

SQL Query

From : https://answers.atlassian.com/questions/93165/find-which-workflows-that-uses-a-specific-validation-plugin

SELECT   workflowscheme.name,   workflowschemeentity.scheme,   issuetype.pname,   workflowschemeentity.issuetype FROM   issuetype,   workflowschemeentity,   workflowscheme WHERE issuetype.id = workflowschemeentity.issuetype and workflowscheme.id = workflowschemeentity.scheme and   workflowschemeentity.workflow in     (SELECT         jiraworkflows.workflowname     FROM         jiraworkflows     WHERE         jiraworkflows.descriptor like '%com.company.plugin%');

JIRA Python script : iterate to get the JQL result

Python 2.7 script to :

• query the result of a JIRA search query in JQL
• iterate so that we do not get all the data at once but only by small batches
• print the result list

Pre-requesites :

• python
• https://pypi.org/project/atlassian-python-api/
• https://atlassian-python-api.readthedocs.io/en/latest/index.html
• some JIRA Server or JIRA Cloud + credentials
• Note that the auth for JIRA Cloud might change a bit

from atlassian import Jira
import json

#auth for JIRA Server
jira = Jira(
    url='https://support.valiantys.com',
    username='username',
    password='password')
# Get the SERVER issues that are Running
JQL = 'project = DEMO AND resolution = Unresolved AND issuetype = "Story" AND status = "In Progress" ORDER BY cf[16032] DESC, cf[15857] DESC'

data_tmp = {}   # data we progressively get each interation
issues_all = [] # full list of issues
issues_tmp = {} # list of issues during this iteration

next_start = 0
size = 50

while size > 0 :
        print("-------- trying to get issues:%s..%s" % (next_start, next_start+size))
        data_tmp = jira.jql(JQL, start=next_start, limit=size)
        next_start += size
        issues_tmp = data_tmp['issues']
        size = len(data_tmp['issues'])
        issues_all.extend(issues_tmp)

print ("(final) #issues=%s" % len(issues_all))

# now we can do things with the data
for x in issues_all:
print("%s %s %s %s" % (x['key'], x['fields']['customfield_16032'], x['fields']['customfield_15862'], x['fields']['customfield_15857']))

Stress-ng - workload for testing

 (src = https://www.loggly.com/blog/performance-monitoring-aws-cloudwatch-metrics/ )

Step 1. Installing and Running Stress-ng

Stress-ng is a load simulator available for the Ubuntu operating system. The utility has a wide variety of command line switches used for customizing the load. The installation is fairly simple as well:

# apt-get install stress-ng

More details about stress-ng can be found on the Ubuntu man page.

Once the tool is installed, it can be run as a command to simulate a CPU load with the following:

4 worker threads
80% load
Timeout after 25 minutes (1,500 seconds)

# stress-ng --timeout 1500 --cpu 4 --cpu-load 80

CloudWatch Dashboard EC2 CPUUtilizationAs the CPU becomes more and more loaded, the the CPUUtilization metric in CloudWatch also reflects it:

HAR analyser

https://toolbox.googleapps.com/apps/har_analyzer/

JIRA Script Runner log debug

snippet of code to use the output logs in ScriptRunner Adaptavist groovy scripts  

ScriptRunner log.debug

tool	ScriptRunner for JIRA
version	8.1.1
use case	log.debug SR script

/***********/ import org.apache.log4j.Logger import org.apache.log4j.Level   def log = Logger.getLogger("com.scriptname") log.setLevel(Level.DEBUG) /***********/   //and then, for example to print the variable trem log.debug "trem=${trem}"

example : 

Mac OS X : show (hidden) .files in the finder.

Finder options:

1.  CMD + Shift + .

Terminal options + restart finder:

1. Open Terminal found in Finder > Applications > Utilities.
2. In Terminal, paste the following:
     defaults write com.apple.finder AppleShowAllFiles YES.
3. Press return.
4. Hold the 'Option/alt' key, then right click on the Finder icon in the dock and click Relaunch.

from :

https://ianlunn.co.uk/articles/quickly-showhide-hidden-files-mac-os-x-mavericks/

Curl : get cert and connect using it

 Obtain cert from self signed site

openssl s_client -showcerts -connect 75.74.58.21:443 </dev/null 2>/dev/null | sed -n '/-----BEGIN CERTIFICATE-----/,/-----END CERTIFICATE-----/p' | grep -m1 -B-1 -- '-----END CERTIFICATE-----'  > cert.pem







Connect with cert

curl --cacert cert.pem https://hostname.com 

3D design tools for free

Inspired by an online post,

• Fusion360 : with an "enthusiast licence"
• Maya LT : used in the industry, there seems to be 
• Blender : no, good for art but not for 3D modeling. Save revisions,  save often, save each item so to be able to go to "stl repair" and import objects back. Boolean can kill objects.
• Sculptris for sculptures.
• Thinkercad.com : cool for beginners ?
• Shapr3D / only on an IpadPro ?
• Open Scad : for mechanical modeling or parametric designs ?
• SolidWorks ($$$)
• FreeCAD
• 
  

Blender :

Organic design; modeling/animation/rigging

Fusion 360 :

Technical design, with precise mesures, CAD, timeline / parametric features

cf. youtube Lars Christensen 

Bamboo concepts for continuous integration : plan / stage / jobs / tasks

Example : 

 

JIRA Xporter plugin - tips and tricks

Tips for  the plugin Xporter 

plugin : https://marketplace.atlassian.com/apps/891368/xporter-export-issues-from-jira?hosting=server&tab=overview

• Print the current date
• Count number of issues in a JQL
• Sum a CF for all issues on a JQL
• Number of links
• Number of issues in a JQL (number format)
• Format a number with locale's decimal separator
• SUM Excel correct values in wrong locale format (workaround)
• Iteration on issue & subtasks

Print the current date

tool	Xporter
version	5.0.0
use case	Print the current date

Document generated at %{(new Date()).getDate() + "/" + ((new Date()).getMonth()+1) + "/" + (new Date()).getFullYear()}

Count number of issues in a JQL

tool	Xporter, excel
version	5.0.0
use case	Count number of issues in a JQL

Excel

JQL	<filter>
nfiches1	${jqlcount:
nfiches2	}

usage

=CONCATENATE(nfiches1;<JQL>;nfiches2)

example

${jqlcount:project = PJAB AND issuetype = Pénal AND created >= -90d AND status not in ("Constitution du dossier", "Saisir Avocat") AND Entité = "AXA Banque"}

Sum a CF for all issues on a JQL

tool	Xporter, excel
version	5.0.0
use case	Sum a CF for all issues on a JQL

Excel

JQL	<filter>
CF	<cf name>
nsomme1	${set(count,0)} #{for n=JQLIssuesCount|clause=
nsomme2	} #{if (%{'${JQLIssues[n].
nsomme3	}' .length > 0})} ${set(count,%{${count} + ${JQLIssues[n].
nsomme4	}})} #{end} #{end} %{Number(${count}).toFixed(2)}

usage

in a excel cell :

=CONCATENATE(nsomme1;<JQL>;nsomme2;<CFname>;nsomme3;<CFname>;nsomme4)

example

${set(count,0)} #{for n=JQLIssuesCount|clause=project = PJAB AND issuetype = Pénal AND created >= -90d AND status not in ("Constitution du dossier", "Saisir Avocat") AND Entité = "AXA Banque"}  #{if (%{'${JQLIssues[n].Créance comptable}' .length > 0})}  ${set(count,%{${count} + ${JQLIssues[n].Créance comptable}})}  #{end}  #{end}  %{Number(${count}).toFixed(2)}

Number of links

tool	Xporter, excel
version	5.0.1
use case	Number of links matching a criteria (including creation date)

• Count the links :
  This requires to set a counter, and iterate over the links returned by "LinksCount".

• Filter on a date :
  This requires to create different Date objects, either initiated with the date returned from the issue, or the calculated date. In the end we are indeed comparing milliseconds since 1-1-1970, so the > is enough.

  /*  test if the creation date is within the last 90 days */ (new Date('${dateformat("yyyy-MM-dd HH:mm:ss"):Links[n].Created}') > (new Date(new Date().setDate(new Date().getDate()-90))))

example

/* Set the variable countD4 to the number of links to the current issue "A" where : * link with the current is :  "A" -(est modifié par)-> other issue * linked issue was creted less than 90 days ago * linked issue type is "Créa-Modif Document". */ ${set(countD4,0)} #{for n=LinksCount|filter=%{('${Links[n].LinkType}'.equals('est modifié par')) && (new Date('${dateformat("yyyy-MM-dd HH:mm:ss"):Links[n].Created}') > (new Date(new Date().setDate(new Date().getDate()-90)))) && '${Links[n].IssueTypeName}'.equals('Créa-Modif Document')}} ${set(countD4,%{${countD4}+1})}     * ${Links[n].Key} ${Links[n].Summary} ${Links[n].IssueTypeName}  ${Links[n].Status} #{end} ${countD4}

Number of issues in a JQL (number format)

tool	Xporter, excel
version	5.0.1
use case	Count the number of issues, and print it in excel JQL format

• ${jqlcount:<JQL>} : counts the number of issues returned by the JQL
• %{Number(<...>)} : make sure it's rendered as a number in excel, for example to use it with =SUM() excel function

example

%{Number(${jqlcount:project = PJAB AND issuetype = Pénal AND created >= -92d AND status not in ("Constitution du dossier", "Saisir Avocat") AND Entité = "AXA Banque"})}

Format a number with locale's decimal separator

tool	Xporter
version	?
use case	Format a number with specific locale's decimal separator

• use the ${numberformat("fr","#,##0.00#") function

example

${numberformat("fr","#,##0.00#"):JQLIssues[j].Montant de l'opération (en €)}

SUM Excel correct values in wrong locale format (workaround)

tool	Excel, Xporter
version	5.1.1
use case	Sum values that Xporter printed in the wrong locale.

• Sometime Xporter has some trouble printing numbers that are actually recognized as numbers by excel. An example is by

example

let's say you need to sum values in a locale where the decimal separator is ",", but xporter outputs a decimal separator as "."; hence the =SUM() function will not work.

=SUM(VALUE(CLEAN(SUBSTITUTE(C11;".";",")));VALUE(CLEAN(SUBSTITUTE(C12;".";",")));VALUE(CLEAN(SUBSTITUTE(C13;".";","))))

Iteration on issue & subtasks

tool	Excel, Xporter, ScriptRunner
version	5.1.1
use case	Bulk export, export the issues & insert their subtasks

• One way of doing so is to use the ScriptRunner JQL functions "subtasksOf(<key>)" and iterate on it.

example

#{for j=JQLIssuesCount|clause=project = PRF and issueFunction in subtasksOf("key = ${Key}") and issuetype NOT IN ("Débit", "Crédit") order by updated }