This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
Remedy AR System Server
Smart Reporting Remedy
Smart Reporting 9.1
Smart Reporting DB is consuming disk space.
The DocumentData table appears to be the culprit.
There is a setting in Smart Reporting to configure report caching that allows the user to keep the latest result sets, instead of of the complete set archived over a period.
- Login to the Smart Reporting using a Report Admin User
- Admin Console > Content Categories > Navigate to the respective Report category Eg. Change Management
- Navigate to Report Version History > Select the Version History option to "Only keep the latest result set" > Click Save
Please note that this may be cause some overhead on DB transaction log, so please ensure you have a DB setting in place to take care of this.