Finding users & issues

This applies only to Jira Server & DC

Find users of the add-in

In case you want to lookup users of the add-in, there is a semi-reliable way to do so, by using the application link data. We have no information if Jira actually retains this information for a longer period of time, so it may be inaccurate.

Use the following two SQLs to find logged in users (we had two different applinks in the past).

SELECT user_name, first_name, last_name, email_address FROM cwd_user 
  WHERE user_name IN (SELECT username FROM oauthsptoken WHERE consumer_key = 'jiraforoutlook')

SELECT user_name, first_name, last_name, email_address FROM cwd_user 
  WHERE user_name IN (SELECT username FROM oauthsptoken WHERE consumer_key = 'yasoonjira')

Find issues created by the add-in

We store an entity property on each issue that is created from Outlook, you can find them by using the following SQL:

SELECT * from entity_property WHERE property_key = 'yasoon-outlook-email-data'