Database Cleanup Tab of the Report Server Form

Use this tab in the Report Administration utility to delete orphaned reports, cached invoice templates, and old log files.

This tab displays when either of the following apply:

  • The SaaS / Hosted Instance checkbox is not selected on the General tab of the Weblink utliity. (You use the Vantagepoint on-premises product.)
  • The SaaS / Hosted Instance checkbox is selected on the General tab of the Weblink utility and the Private SaaS checkbox is selected on the System Settings tab of the Weblink utility. (You use the Vantagepoint cloud product.)

Contents

Orphaned Report Files Section

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 that you entered.
Delete Reports Click this button to delete orphaned report files that are older than or equal to the specified number of days. You are prompted to confirm the deletion.
Schedule Delete Click this button to schedule the deletion process to run at a later time.

Report Log Rows Section

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 button to delete report log rows that are older than or equal to the specified number of days.
Schedule Delete Click this button to schedule the deletion process to run at a later time.

Report Archives Section

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 Toolbar

Field Description
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. On the Print Preview form, 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 grid data or to save the spreadsheet file locally.
  • To enable grouping for a grid, click Enable Grouping. When a field displays with the instruction to "Drag a column header here to group by that column," you can drag and drop column headers into the 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 then click this option on the grid toolbar.

Report Archived Grid Fields

Field Description
Username This column displays the Vantagepoint 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 Vantagepoint 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.

Cached Invoice Template Files Section

Field Description
Total Cached Invoice Templates This field displays the total number of cached invoice templates that will be deleted.
Delete Cached Invoice Templates Click this button to delete the number of cached invoice templates that are displayed in the Total Cached Invoice Templates field. You are prompted to confirm the deletion.
Schedule Delete Click this button to schedule the deletion process to run at a later time.

Planning Table Sections

Field Description
Total Unused Planning Tables This field displays the total number of unused planning tables that will be deleted.
Delete Unused Planning Tables Click this button to delete unused planning tables that are displayed in the Total Unused Planning Tables field. You are prompted to confirm the deletion.
Schedule Delete Click this button to schedule the deletion process to run at a later time.