Filed Under (Tips and Tricks) by Marc Champoux on March-4-2010

Summary
  

The Mail Tracking Store has been around for a while in our Yellowverse. And as an admin, you are well aware of the fact that it’s super useful when it comes to troubleshooting mail issues (with the usual requested being “I sent this to Mr. Smith but he says he never got it” and a couple clicks later you can tell them that Mr. Smith deleted it).
  

However, one weird thing about the Mail Tracking Store is that it only keeps 30 days of data by default. In case you are wondering, the number of days of data that it keeps is controlled by the field “Remove documents not modified in the last (days)” of the “Space Savers” tab of the Replication Setting panel for the MTSTORE.NSF database on your server.
  

Nothing stops you from changing that value to 60, 90, 180 days or more! But what happens when you need to update that setting on ALL your Mail Tracking Store databases on ALL your servers? It’s easy to do it manually if you only have a couple servers … but what happens when you have 10, 20, 50 or 100 servers?
  

Well, you either put yourself on “Do Not Disturb” for the next couple days and you do the update manually OR you write some code OR, better yet, you “borrow” my code!
  

So, Where’s The Code?
  

Right below … patience … because before you download it and import it into a button (or Agent that you can run from the Action menu), you need to know what it does:
  

1. The code will prompt you for the number of days.
2. The code will then try to open the Domino Directory on your server.
3. The code will then try to open the “Servers\Servers” view in the Domino Directory.
4. The code will then prompt you to select the servers to scan for a Mail Tracking Store database.
5. The code will then go to each of the selected server and check their Mail Tracking Store database settings.
6. The code will update each Mail Tracking Store “Days to Keep” to the setting you selected in step 1 (if does not match).
   

That’s it … simple as that. The code is below and you can simply click on the image below to download it. You can then import it into a LotusScript button or Agent set to run from the View Action menu to update your Mail Tracking Store settings.
  

 

 

 

   
  

Addendum
  

Part 1 – If you want my opinion, don’t wait until the CIO asks you to do a Mail Tracking on a “questionable” email sent by an employee 4 months ago to update your Mail Tracking Store settings … do it now!
   

Part 2 – Maybe someone else already wrote something that does that … I’m sorry if that’s the case … I was in a hurry to get this done.
  

Part 3 – However, I wonder why this isn’t controlled by a field in a Configuration Setting document … maybe there’s an IdeaJam out there for this?
   

Thanks for reading!
  

Marc