Making Any Minor Change to an RO Results in a Flood of Duplicate Resolution Notifications
This is very frustrating and has resulted in complaints from end users who have received a bunch of emails for tickets resolved or completed a while ago (we have the Auto Close setting set to 21 days).
I understand this is because the "Last Modified" date gets reset each time which is ultimately the cause, but my main question is, do others encounter this issue? If so, how do you get around it?
As an aside, our SQL database filled up recently with the following (Service Manager/non-Cireson) database filling up with an insane amount of records:
After some research, we figured this was responsible for holding the "History" information. We had our history set to 365 days and we've reduced it right down to 60 days, but even after an overnight clean up job the size only dropped by 1GB, suggesting the vast majority of records are under 60 days old. This probably means it's, again, somehow tied in to my small changes to our ROs. Is each change stamping new history on all the old incidents and service requests?!
Any advice/information gratefully received!