Is there a way to share a .csv or excel of a service desk queue?

[Kirsty Maitland]

Is there a way to share a .csv or excel of a service desk queue? If there is can we automate this to be sent via email on a weekly basis? 

[Marc -Devoteam-]

Hi @Kirsty Maitland 

Welcome to the community.

A JSM queue is based on a filter. Use the filter clause from the queue in the Find all items and export the found information.

See this post as a reference: How-do-I-export-all-issues-to-excel-or-CSV-with-Jira-project 

You can use the same JQL to use in automation to lookup issues and sent a list of the found issues per mail.

See this KB article: automation-rule-to-send-single-email-for-all-issues 

[Aron Gombas _Midori_]

@Kirsty Maitland You can easily solve it with the Better Excel Automation app. 

As part of standard Jira automation rules, it can create custom Excel sheets by executing a JQL on a schedule, attach that to an email and send that to a set of email addresses. As your Service Management queue is configured with a JQL query, you can just copy that from the queue config to the automation rule config, and it will produce the same list of issues.

A rule looks like this:

Here is the step-by-step guide (and video).

(Discl. this app is developed by our team.)