[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