Home Home
  login

Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Does a last modified by or equivalent field exist?

items
custom-fields
reporting

I am looking for a way to check who the last person to modify a ticket was? Is this stored somewhere?

User56024
· 1
User56024
Replies (5)
helpful
0
not helpful

If you check the history for that ticket you will be able to see who modified it.


Simran
· 1762
Simran
helpful
0
not helpful

I see that I can do that, but I'm more of looking for a way to provide a report with the last modified by field. Not so much going into an individual ticket basis.


User56024
· 1
User56024
helpful
0
not helpful

gemini_userhistory.username, history, and created columns have this info. Don't know if there are any Gemini reports that use these columns. You could always write a SQL query.


Rick Starr
· 100
Rick Starr
helpful
0
not helpful
ANSWER

The table is gemini_issuehistory.


Rick Starr
· 100
Rick Starr
helpful
0
not helpful

I just came across that in SQL, looks like I will write a report based on that! Thanks.


User56024
· 1
User56024