[rt-users] Searching for the To: field within RT?

[Travis Campbell]

> In that case, you would have to do a SQL query:
> 
> SELECT Headers FROM Attachments WHERE Headers LIKE '%To:
> <legacyqueuename at yourdomain.com>%';
> 
> If you only want this for when a new ticket was created via email
> (rather than for responses to those tickets), add: 
> 
> AND Headers NOT LIKE '%Thread-Topic: [<yourdomainname.com>%'
> 
> Or whatever you have set as $rtname in RT_SiteConfig.pm.  And then have
> a Perl script that just greps out the From: line from all of those
> headers.

Thanks.  That's what I was leaning towards if RT didn't have an explicit
way to do it via the search API.

Travis

-- 
  Travis Campbell  -  Unix Systems Administrator =    travis at mpdtxmail.amd.com
     5900 E. Ben White Blvd, Austin, TX 78741    =     travis.campbell at amd.com
     TEL: (512) 602-1888  PAG: (512) 604-0341    = webmaster at mpdtxmail.amd.com
=============================================================================
       "Does anything work as expected?"  Yes.  An axe through the CPU.