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

Better Late than Never …
  

Patrick and I had noticed the DominoDefrag project on OpenNTF a while ago. Patrick had said to me “when you have a minute, test it out in the test environment”. Well, that was a long time ago and yesterday I noticed a week old post on PlanetLotus.org that version 2.2 of DominoDefrag had been released. So, I decided it was time to test it out.
  

The installation instructions are quite simple and extremely well documented so getting it up and running was just a matter of putting myself on Do-Not-Disturb for a couple minutes.
  

And The Results?
  

Seriously, give Andrew Luder, the creator of DominoDefrag a medal. Give him something. Anything. The results are nothing short of amazing!
  

For example, in my test environment, the File Fragmentation went from 91% to 31% on the 1st pass. After a 2nd pass it went down to 30%. I checked and I realized that the 30% left were files that were not Domino databases so I ran the usual Windows Disk Defrag utility and it brought the File Fragmentation down to 0%. Simply put: amazing!
  

Also, while Domino Defrag was running in my test environment, I was checking the server console to see which database it was defragging. And for test purposes (because I really don’t care about the data in the test env.), I opened certain very large databases when it was defragging them. I even added/deleted documents in those databases *while* they were being defragged and didn’t notice any performance hit. Once again … amazing!
  

And maybe it’s me but the database operations, i.e. opening a database, opening views, opening documents, editing documents, etc, etc was quickr and faster … too bad I had not done metrics tests on those database operations before to compare with the after.
   

So, after doing a bunch more tests in the test environment, I deployed it to my production servers.
  

In production, my busiest server had 99% File Fragmentation. It took all weekend but on the 1st pass, the File Fragmentation went from 99% down to 30%. Again, the 30% left were files that were not Domino Databases so I ran the Windows Disk Defrag utility and it brough the File Fragmentation down to 0%.
    

The screenshots below are from my test server … but see for yourself the results in a Test environment and imagine the results in Production (they’re amazing):
   

DominoDefrag - Before

DominoDefrag - After it has ran once and defragged all the NSFs, NTFs and Full-Text Indexes

DominoDefrag - Final Result after using the Windows Disk Defragmenter to clean up all the other files on the D: drive

In Conclusion …
  

Seriously, anyone dealing with a slow server should consider installing this on their server. Of course, test it out in your test environment before!
  

Thanks for reading!
  

Marc

Summary

Quick post about a weird copy-paste issue when you do a mail-tracking for someone and there are a lot of tracking results (I discovered this when doing a mail tracking on an email that was sent company wide with more than 500 results).

The Issue and how to reproduce it …

(a) You open your Lotus Domino Administrator client. You to the Messaging -> Mail Tracking tab and you perform a Mail Tracking.
(b) Cool: there’s a ton of results! So you click on Edit -> Copy and then go back to reply to the person to “show” her who she sent the email to (500+ people like I said).
(c) In the reply, you click on Edit -> Paste … and then you are puzzled because only the last 30 some mail tracking results show up … that’s odd.
(d) You re-try the same thing over-and-over again. You even try with your Lotus Notes Administrator client R7.0.2 and R8.5 clients … same result!

The Solution? None … yet.

I opened a PMR with Lotus Support and learned that this has already been reported and has been submitted in an Enhancement request. The number for the SPR is JPIK5XSQBY. I wish I could post a link here but I couldn’t find where it’s listed. I’m pretty sure there’s an IdeaJam out there for this bug but I haven’t searched for it either.