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'