Reporting on Rogue Admins?
I'm running 7.60 build 7610 on MS SQL Server.
I'd like to be able to track down the activity of a "rogue" admin who has been dispatching tickets outside of our standard process. The thing is, I can't figure out how to show in a report the person who dispatched a ticket. I need a query that will show me all of the tickets where the "Request Updated by:" as found in the history tab of request tickets is "X" where "X" is the name of the admin. Additionally having the "Request Updated by:" be listed for everyone with a specific role for a given period of time would be a good query to have as well.
Thanks!
I'd like to be able to track down the activity of a "rogue" admin who has been dispatching tickets outside of our standard process. The thing is, I can't figure out how to show in a report the person who dispatched a ticket. I need a query that will show me all of the tickets where the "Request Updated by:" as found in the history tab of request tickets is "X" where "X" is the name of the admin. Additionally having the "Request Updated by:" be listed for everyone with a specific role for a given period of time would be a good query to have as well.
Thanks!