CA Client Automation

Reporter Cleanup.docx 

10-19-2015 12:05 PM

Many customers have 100's of temporary tables filling up their MDB.

 

many of these tables have the following naming patterns:

R0?????

R0?????_M

RPTMP_????????_0?

 

These are all Reporter and Reporter Results tables.

 

Too many of these can cause Space and Performance issues.

 

The attached Document has 2 Queries:

 

1. Lists all the Reporter Results for all you Reports

 

2. Allows User to Delete All Reporter results over X number of days

 

This should in turn clean up a lot of the Reporter temp tables.

Statistics
0 Favorited
0 Views
1 Files
0 Shares
0 Downloads
Attachment(s)
docx file
Reporter Cleanup.docx   13K   1 version
Uploaded - 05-29-2019

Tags and Keywords

Comments

10-19-2015 01:12 PM

Great Gordon!

Related Entries and Links

No Related Resource entered.