Is there a time stamp stored each time the area is changed? I have looked
through the source, but have not had any luck tracking this down. Thanks
in advance for your help.
Cameron
Texterity – The Art and Technology of Text
Cameron H. Murrell cmurrell@texterity.com
Software Engineer (508) 804 3050
Texterity, Inc. (508) 804 3110 fax
144 Turnpike Rd. www.texterity.com
Southborough, MA 01772 www.textcafe.com
Is there a time stamp stored each time the area is changed? I
have looked through the source, but have not had any luck tracking
this down. Thanks in advance for your help.
Cameron
Yes, you can find when a ticket’s area has changed:
(example:)
/usr/local/mysql/bin/mysql -u root -p rt
Password: ***********
mysql> SELECT * FROM transactions WHERE type = ‘area’ AND
actor = ‘apthorpe’
→ ;
| id | effective_sn | serial_num | actor | type | trans_data |
trans_date |
| 307 | 65 | 65 | apthorpe | area | DNS |
965692014 |
| 1287 | 58 | 58 | apthorpe | area | AU |
970524921 |
| 1314 | 284 | 284 | apthorpe | area | ES |
970593071 |
3 rows in set (0.01 sec)
The SQL query
SELECT * FROM transactions WHERE type = 'area'
will give you all fields of all transactions where the area was set or
changed; the trans_date field contains the serial time of the change
(seconds since Epoch, midnight 1/1/1970 GMT) which you can
reformat into a more pleasing date.
Look at the source of one of the report generators in the contrib
directory for examples of how to run your own queries against the
RT database.
hth,
– Bob