Skip to content

Instantly share code, notes, and snippets.

@borwick

borwick/gist:6c49a59b8fa47040b184e4796bdb4195

Created June 27, 2019 17:31
Show Gist options
  • Save borwick/6c49a59b8fa47040b184e4796bdb4195 to your computer and use it in GitHub Desktop.
Save borwick/6c49a59b8fa47040b184e4796bdb4195 to your computer and use it in GitHub Desktop.
Download ZIP
Find who forwarded to whom in RT
Raw
gistfile1.txt
SELECT Tickets.id, Users.EmailAddress, t.Data
FROM Transactions t, Tickets, Users
WHERE t.Created > DATE("2019-03-01") AND
t.ObjectId=Tickets.id AND
t.Type LIKE 'Forward%' AND
t.Creator = Users.id
ORDER BY Users.EmailAddress, t.Data, Tickets.id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment