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
SELECT
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 ?
RTxAssets
RTxCatalogs
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
---------
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Los Angeles - September, 2016
