Remove legacy (Actuate) reports from Maximo
Remove legacy (Actuate) reports from Maximo
September 7, 2014
If you are upgrading from Maximo 5 or 6, to Maximo 7.1 or 7.5, you may want to remove legacy (Actuate) Maximo 5 or 6 reports.
The following SQL script deletes those obsolete report entries from the database.
delete from reportlookupwhere reportlookup.reportnum in(select reportnum from reportwhere runtype in ('ESPREADSHEET', 'QUERY', 'REPORT'))or reportlookup.reportnum is nullor reportlookup.reportname is null;delete from reportlabelwhere reportname like '%.rox'or reportname like '%.dox'or reportname like '%.vts'or reportname like '%.vtf';delete from reportwhere reportname like '%.rox'or reportname like '%.dox'or reportname like '%.vts'or reportname like '%.vtf';Reference: Maximo Wiki - Deleting reports