[rt-users] RT 4.4: Leftover RTx Tables in DB

Kevin Buckley kevin.buckley.ecs.vuw.ac.nz at gmail.com
Mon Jul 18 23:56:40 EDT 2016

Been following/using RT's Assets since the Extension days but had upgraded
to RT 4.4.0rc1 a while back now.

Came to run an SQL query, held in a file, against the underlying DB, so as
to produce some output in a format that matches that shown in a vendor's
portal display.

Was mystified as to why a couple of recent additions to my Asset catalogs
were not showing up.

Eventually realied that the SQL query had been written thus

       SuppSNum.Content as 'Serial Num',
       RPAD(RTxAssets.Name, 20, ' ') as 'Host name',
       SuppSite.Content as 'Site Id',
       Warranty.Content as 'Expiration Date'
  FROM RTxAssets,
       ObjectCustomFieldValues as Warranty,
       ObjectCustomFieldValues as SuppSNum,
       ObjectCustomFieldValues as SuppSite

so against the old RT::Extension tables, which are clearly still within the DB.

Dropping the RTx so as to query the upgraded tables gave me the current details.

Can I just bin the (two ?) RTx tables ?


or are there "things to look out for" ?

Kevin M. Buckley

eScience Consultant
School of Engineering and Computer Science
Victoria University of Wellington
New Zealand

More information about the rt-users mailing list