Hello,
We're looking to reclaim some license keys from unused accounts, but we utilize a plugin that lets users comment via email, so users who are active on Jira don't necessarily login often. We thought that we could identify users who aren't active by their last comment date instead of last login date, and have been working hard to write a SQL query to pull this information from the Jira DB, but we're not entirely sure in which table the last comment date would be stored. Can someone please point me in the right direction, or help me identify a better way to determine unused licenses in our situation?
Thank you!
