Database Cleanup Tab of Report Administration

Use the Database Cleanup tab to delete orphaned reports and old log files.

Contents

Orphaned Report Files

Field Description
Report RDL Files That Have Been Orphaned for This Number of Days Enter the minimum age in days for orphaned report files that can be deleted. For example, to delete report files that are 10 or more days old, enter 10.
Total Orphaned Reports (Including Subreports) This field displays the total number of orphaned reports and subreports that will be deleted, based on the number of days you entered.
Delete Reports Click this option to delete orphaned report files that are older than or equal to the specified number of days.
Schedule Delete Click this option to schedule the deletion process to run at a later time.

Report Log Rows

Field Description
Report Log Rows That Are Older Than This Number of Days Enter the minimum age in days for log file rows that can be deleted. For example, to delete rows that are 10 or more days old, enter 10.
Total Report Log Entries This field displays the total number of log file rows that will be deleted, based on the number of days you entered.
Delete Log Rows Click this option to delete report log rows that are older than or equal to the specified number of days.
Schedule Delete Click this option to schedule the deletion process to run at a later time.

Report Archives

Field Description
Report Archives That Are Older Than This Number of Days Enter the minimum age in days for archived report files that you want to display in the grid. For example, to display report files that are 10 or more days old, enter 10.

After you enter the number of days, click Refresh on the grid toolbar to display the archived reports that are that old or older.

If you leave this field blank and click Refresh, the grid displays all archived reports.

Report Archives Grid Dropdown Click the drop-down arrow on a grid header to complete any of the following actions:
  • To print grid data, click Print. When the Print Preview form displays, click File > Print to send the grid data to your default printer.
  • To export grid data to an Excel spreadsheet, click Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the data, or to save the spreadsheet file locally.
  • To turn on grouping for a grid, click Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into this field, in the sequence that you want them to display.

Not all options are available on all grids.

Refresh After you enter a number of days old in Report Archives That Are Older Than This Number of Days, click Refresh on the grid toolbar to display the reports that are that old or older.

If you leave Report Archives That Are Older Than This Number of Days blank and click Refresh, the grid displays all archived reports.

Delete To delete a report, click the report and click Delete on the grid toolbar.
Username This column displays the Vision username of the person who created the archived report.
Folder This column displays the area of Reporting from which you generate the report. For example, if you go to Reporting > Contact to generate the report, this field displays Contact.
Report Name This column displays the name of the archived report.
Created Date This column displays the date that the archived report was created.
Expiration Date This column displays the date and time that Vision will automatically remove the archived report.

The expiration date and time is based on the number of archive hours that was specified when the report was archived or scheduled to be archived.