Skip to content
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



Share this:
Twitter Facebook LinkedIn