Can anyone kindly tell me where I would find information relating to ticket owner changes in the database?
I'm writing a custom report, and can't seem to figure out where this information is recorded in the DB.
Any help would be appreciated.
Cheers,
Rohan.
Ticket Owner Information in the database
Moderator: crythias
-
root
- Administrator
- Posts: 4253
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Ticket Owner Information in the database
Hi Rohan,
You'll find this information in the ticket_history table.
hth, Roy
You'll find this information in the ticket_history table.
hth, Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
rhare
- Znuny newbie
- Posts: 2
- Joined: 09 Jul 2015, 01:30
- Znuny Version: ITSM4
- Real Name: Rohan Hare
- Company: Harper Grey LLP
Re: Ticket Owner Information in the database
Thanks.
I probably should have asked for more specifics, however I ended up managing to find what I was looking for.
In the event anyone else has the same question:
Linking ticket, ticket_history and ticket_history_type tables together, ticket_history_type.id 23 is 'Owner Update'.
Using this I'm able to count how many times a ticket changed ownership.
Cheers,
Rohan.
I probably should have asked for more specifics, however I ended up managing to find what I was looking for.
In the event anyone else has the same question:
Linking ticket, ticket_history and ticket_history_type tables together, ticket_history_type.id 23 is 'Owner Update'.
Using this I'm able to count how many times a ticket changed ownership.
Cheers,
Rohan.