How to send reports or filters automatically via emails in excel or csv format

[Prachi Nema]

Dear All,

I want to fetch a report which includes count of Open, Resolved tickets and SLA success rate of Response and resolution SLA  of One day data within in a one report only and send via email in a excel or csv format without any manual intervention.

Actually in that report, team wise issue created and resolved count and response and resolution SLA success rate with respective teams. I want all these conditions in one report only.

I  have tried filter section of issues but it doesn't include the count of tickets and also it have the option subscription which can help to send via email but not in excel or csv format.

I have also tried Report section , in which Count is available but send via email functionality is not available and also it is showing data of 48 hours Or 7 days , I want to display data of  one day only in that report.

I am using Jira Service Desk 3.16.0.

Please help me with this and let me know if any work around is available.

Regards,

Prachi

[Mohamed Benziane]

Hello @Prachi Nema 

You can may be try the jira cloud add-on for google sheets, it allow you to create a report based on a filter.

You will be able to choose when to update automatically the data.

https://support.atlassian.com/jira-core-cloud/docs/use-jira-cloud-for-sheets/

https://community.atlassian.com/t5/Jira-articles/Try-the-new-Jira-Cloud-add-on-for-Google-Sheets/ba-p/1016436

Hope this helps

[Prachi Nema]

Thanks for your respone. @Mohamed Benziane 

[Boris Berenberg - Atlas Authority]

You can send a list of issues like this within the body of the email using Notification Assistant for Jira. At this time, we don't support CSV or Excel as an attachment.

[Aron Gombas _Midori_]

It is a duplicate of this other question.

Find the answer there!

[PhilSpo]

I use xporter for this. Works well.

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