Finding tickets based on changed field

RT Users
1

Is there a method to find all tickets which have had a custom field
edited/changed in the last 30 days?

Vance Walsh
Network and Systems Administrator
Concord Academy - Concord, Mass.

2

Vance,

I don’t think you can do that with standard RT-SQL. I would imagine you
could do it directly from the DB via SQL by looking at the “LastUpdated”
date field of the OBJECTCUSTOMFIELDVALUES table.

Kenn
LBNLOn Mon, Apr 11, 2011 at 6:32 AM, Vance Walsh <vance_walsh@concordacademy.org wrote:

Is there a method to find all tickets which have had a custom field
edited/changed in the last 30 days?

Vance Walsh
Network and Systems Administrator
Concord Academy - Concord, Mass.

3

Hello,

Only with SQL or custom code, not from UI.On Mon, Apr 11, 2011 at 5:32 PM, Vance Walsh vance_walsh@concordacademy.org wrote:

Is there a method to find all tickets which have had a custom field
edited/changed in the last 30 days?

Vance Walsh
Network and Systems Administrator
Concord Academy - Concord, Mass.

Best regards, Ruslan.