Is it possible to get a count of how many Jira issues were created from Salesforce?

  • 1
  • Question
  • Updated 2 years ago
  • (Edited)
I'd like to be able to run a report (either in Salesforce or in JIRA) to get a count of how many Issues were created from Salesforce.  Basically to get a count of how many tickets are going through the connector to be able to measure user adoption.
Any suggestions on how this could be done?
Thanks!
Photo of Allison Humphrey

Allison Humphrey

  • 4 Posts
  • 0 Reply Likes

Posted 2 years ago

  • 1
Photo of Adrien Low

Adrien Low, Alum

  • 85 Posts
  • 3 Reply Likes
Hello Aliison,

It would be great if you could provide us with your JIRA and Connector version.

Regards,
Adrien
Photo of Allison Humphrey

Allison Humphrey

  • 4 Posts
  • 0 Reply Likes
Adrien - 
Here is a list of all the connector plugins

ServiceRocket Core Connector - Plugin = 2.0.14
ServiceRocket JIRA Connector - Plugin = 2.0.14
ServiceRocket Salesforce.com Connector Plugin = 6.0.13

Thanks,
Allison
Photo of Adrien Low

Adrien Low, Alum

  • 85 Posts
  • 3 Reply Likes
Hello Allison,

There is currently no direct way to determine the number of JIRA Issues that was created from Salesforce.

Perhaps you can try using JQL functions to determine the number of JIRA Issues that are associated to a Salesforce Object.

To search for all JIRA issues associated to a Case object:-
  1. Proceed to JIRA -> Issues -> Search for Issues -> Click Advanced
  2. Insert the following JQL into the the search-box "CaseReferenceFieldName" != Empty
  3. Hit Enter
  4. The number of JIRA Issues that are associated will be displayed.
If you have other Remote System Reference field, you would have to use OR like so,

"CaseReferenceFieldName" != Empty OR "RemoteSystemReferenceFieldName" != Empty

and so on. 



Of course, with this you will not be able to tell if the JIRA issues were created from Salesforce or vice versa or if you have manually associated the JIRA issues. Associations that were unlink will also not appear in the search results.

Regards,
Adrien
(Edited)
Photo of Allison Humphrey

Allison Humphrey

  • 4 Posts
  • 0 Reply Likes
Thanks Adrien.  
This will for what I need right now.
Photo of Adrien Low

Adrien Low, Alum

  • 85 Posts
  • 3 Reply Likes
Hello Allison,

Glad to be able to help. Do not hesitate to contact us for any other enquiries you may have.

Regards,
Adrien