Deleting Ad Hoc Reports
As a part of a report cleanup exercise (analysing YF metadata to identify drafts and reports not run in a certain date range), I've noticed all ad hoc reports remain in the metadata as draft but not accessible in the UI.
The intent of the cleanup is to remove unneeded content and lessen the load on views when they are cloned and re-activated - views that approach 1000 active reports tend to error and can corrupt attached reports.
a) are ad hoc reports included in the view clone metadata update (I assume they are as very old ad hoc reports are tied to the latest active viewIDs), and thus
b) can we mark them as deleted in the metadata (update their status in the reportheader table) to detach them from the view, or
c) is there a better way to achieve this?