How to extract issue history through excel macro?

[Naresh]

Hi, I would like to extract issues history details through excel macro (VBA Script) to know how much time each issue spent in each stage. Please help. 

[Gökçe Gürsel {Appfire} · Accepted solution]

Hi @Naresh ,

Welcome to the Atlassian Community! Is there a particular reason you want to use a VBA Script? Jira has various ways to extract issue history and time spent in each stage but I've not yet seen a VBA Script do this.

Depending on your hosting type I can point a couple of ways to do this:

• If you're using Cloud, I suggest using the Script Runner or Cloud REST API to extract issue history. These are powerful tools that offer users versatile solutions.
• If you're using Server, you can again various scripts but the most convenient way to use is Enhancer Plugin for Jira . It has the Time in Status custom field that is the best fit for your use case. You can also use this custom field for reporting and track a drill-down analysis based on the assignee field.

Let me know if you have further questions.

Cheers,

Gökçe

[Naresh]

Hi @Gökçe Gürsel {Appfire}

Thank you for your response! I need to check with our Admin if we are using Cloud or Server. Meanwhile, could you please share any any screen shot for how to access (where to find if it is there) Script Runner/API for cloud and Enhancer Plugin for server. 

I didn't know there something like these exist, that's why I was thinking of using VBA script. But in case if I have don't have access to these plug ins (sometime companies don't purchase all the plugins), is there any script I can use? 

Best

[Gökçe Gürsel {Appfire}]

Enhancer Plugin is linked here: Link 

You can download it in your instance by navigating to Administrator menu > Manage apps > Find new apps > Type Enhancer Plugin for Jira

You Jira admin can set it up for you, just pass the name of the plugin to her/him.

As for the Cloud instance, Rest API is linked here: Link 

As for the script for Cloud, the community has some answers I'm sure. I'll link it when I come across it.

Cheers,

Gökçe