Is there a way to reduce the size WHD takes up? We're a relatively small company. 7 agent licenses, less than 18,000 tickets and WHD is taking up 96.4GB.
Only using an E-Mail regular expression filter going forward but you will need to put something on every E-Mail signature for the REGEX to check against.
I doubt that E-Mail signatures would generate such a big database size, more likely attachments but a check of the DB Table sizes would confirm this.
When you delete tickets do you have secure delete enabled? As when tickets are normally deleted they don't go, they are simply marked as IsDeleted in the DB. Only if you use secure delete for your tech will this reduce the DB size.... SW Support could help you with a SQL script to clear unwanted deleted tickets if that is the problem...
This is our 'E-Mail Attachment Regular-Expression Filter' found in Setup - Email - Options :
(?i)(smime\.p7s)|(Exemplas\slogo\sRGB\.jpg)|(RTPI-AccPlannProg-Logo-Screen\.jpg)|(Bhire\slogo\.png)|(Bhire-Growth-Hub-Logo\.jpg)|(Logo\sfor\sOutlook\.jpg)|(Outlook-burg\.png)|(Outlook-cid_image0\.png)|(Outlook-GTEA\.png)|(Outlook-TEF\sGold\.png)|(Outlook-u_330\.png)|(Outlook-([a-zA-Z_0-9]{8})\.png)
Use this example to filter your own signature logos etc.
I took a closer look (which I should have done first) at what exactly is taking up all the space and it is the DB backups folder. Each day is about 2.9GB. Right now it's set to keep 30 days. Is there any reason I can't reduce the number of days that are kept? We also backup the whole VM WHD is on.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.