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
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’
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
School of Engineering and Computer Science
Victoria University of Wellington