Export of External custmer - Lact avitivity date

[Danielle David]

Hello,

Trying to export our external customers last activity date with no luck,

In the admin view i can search a customer and see their last activity date, however when i export it only shows added to org date and only last activity for license holders.

Then i though a  workaround would be to export 6 months of tickets to and filter externals etc, however no luck their as only can export 1000 at one time, we get over 2000 a month.

Any other suggestions.

[Joseph Chung Yin]

@Danielle David -

Unforunately, there is nothing that I know of where you can get the information that you are asking for via the UI.

On the external customer's last activities date - I don't believe it is being stored.  In regards to exporting the results, you may want to try the following syntax as recommended in this reference link to export 1000 row at a time.  (essentially, appending 
&tempMax=1000 to your export url to get the first 1000 rows, then using the same URL with the previous setup and append the &pager/start=1000 to get the next 1000 rows.

https://confluence.atlassian.com/jirakb/export-over-1000-results-to-excel-from-jira-cloud-779160833.html

The 1000 row limit is set at the system level for performance reason.  So I would recommend you to contact Atlassian Support (https://support.atlassian.com) to see if they can change the default value for your env or not + assist you on possible records for obtaining your external customer's last activities dates information.

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.