[rt-users] Identify Requestor on Mysql Database
Marcelo Calado | TBS TAX Services
mcalado at tbstaxservices.com
Wed Feb 17 11:02:47 EST 2016
Hi There!
How can I identify the requestor of the ticket on my mysql database? On
Tickets table, there is not a field like "requestor"!
Any suggestion is appreciated..
Marcelo Calado
Field | Type | Null | Key | Default | Extra
|
+-----------------+--------------+------+-----+--------------+--------------
--+
| id | int(11) | NO | PRI | NULL |
auto_increment |
| EffectiveId | int(11) | NO | MUL | 0 |
|
| IsMerged | smallint(6) | YES | | NULL |
|
| Queue | int(11) | NO | MUL | 0 |
|
| Type | varchar(16) | YES | | NULL |
|
| IssueStatement | int(11) | NO | | 0 |
|
| Resolution | int(11) | NO | | 0 |
|
| Owner | int(11) | NO | MUL | 0 |
|
| Subject | varchar(200) | YES | | [no subject] |
|
| InitialPriority | int(11) | NO | | 0 |
|
| FinalPriority | int(11) | NO | | 0 |
|
| Priority | int(11) | NO | | 0 |
|
| TimeEstimated | int(11) | NO | | 0 |
|
| TimeWorked | int(11) | NO | | 0 |
|
| Status | varchar(64) | YES | | NULL |
|
| TimeLeft | int(11) | NO | | 0 |
|
| Told | datetime | YES | | NULL |
|
| Starts | datetime | YES | | NULL |
|
| Started | datetime | YES | | NULL |
|
| Due | datetime | YES | | NULL |
|
| Resolved | datetime | YES | | NULL |
|
| LastUpdatedBy | int(11) | NO | | 0 |
|
| LastUpdated | datetime | YES | | NULL |
|
| Creator | int(11) | NO | | 0 |
|
| Created | datetime | YES | | NULL |
|
| Disabled | smallint(6) | NO
More information about the rt-users
mailing list