V&M Home Page

AVAILABLE for Consultations or Contracting - I hold passports from Canada and The Netherlands. I would be happy to help you - either in person or working remotely.
Email John

One story about a post migration clean up
Domino environments are unique and there is no standard clean up

Recently I finished a mail migration from Notes to Office 365 for a University in the southern United States. They had been using Notes mail for over 15 years. The student mail files had already been migrated. So we only had to worry about Faculty and Staff. The mail migration went smoothly. We had run the migration software ahead of time. So when we flipped the MX record we only had to migrate the Delta. Everyone was ready to go when they arrived to work on Monday.

Now over the years, replica copies had be placed randomly on other Domino servers. Sometimes there were three or four replicas. The University wanted to keep one copy of the Notes mail and wanted to remove the replicas. This recovered space would reduce the strain on the SAN.

There were ten Domino servers in the environment. Two only contained student mail files and could be ignored. While I tested the application that I had written I noted that one server was off line. This one had already be taken down since it only contained training accounts. So we could ignore this server as well. We wanted to leave the mail file that was listed in the Domino Directory and delete the other ones.

Domino Directory
The Domino administrators gave me permission to create a view for this application. They had already created a View themselves to for migration purposes.

The View used the following selection formula.

So we people who have a mail server listed. Then we eliminate the people on domstua and domstub. These were the student mail file servers. Later we changed the formula to disregard the Training server.
When we are complete with removing the secondary mail databases the code adds a field to the person record named MailRemoved with the value "MailRemoved". So that once we process a selected user they will disappear from this view. When this view is empty we are done.

Pretty simple application, one view, one form and one agent

When you click the Remove Secondary Mail you get selection of the users in the special view.

Once the user presses OK the process begins. We open the user's mail file and retrieve the ReplicaID property.
id$ = notesDatabase.ReplicaID

Then we try to open on each server in turn.
flag = notesDatabase.OpenByReplicaID( server$, replicaID$ )
If we find a notesDatabase and it is not on the mail server listed then we delete the database. We mark the Person Document with a new called MailRemoved. So this person no longer shows in the Migration\RemoveMail View.

The status bar shows the progress.

The documents in the view are report documents.

Call notesDatabase.RemoveFTIndex( ) only works on local databases. I didn't get a chance to see if the Call notesDatabase.Remove would remove the Full Text Index.

We actually used the Domino Administrator to remove the Full Text Indexes from the mail directories. .

Hopefully this has given you something to think about.

Author's Background
I am a Notes/Consultant with twenty-seven years of experience (almost exclusively with Lotus Notes / Domino). My experience with Notes began when I worked as a Senior Computer Consultant for Price Waterhouse. In 1993, I went to work for Lotus Development Corporation as a Senior Notes / Domino Instructor. I started teaching Application Development and System Administration with Version 3. Helped to develop the course materials for Version 4.x and Release 5.x When LotusScript, Javascript and Java were added to Notes/Domino I started teaching these programming languages.

In 1995, IBM acquired Lotus. For several years we were left alone and the culture did not change. It was a lot of fun to work for Lotus. In 1999 the handwriting was on the wall and I decided it was time for me to leave. So I established V&M to do Lotus Notes/Domino Application Development, System Administration and Training. I've been at it ever since. The life of the consultant is constantly changing. It has given me the chance to travel across Canada and the United States, Scotland, England, Bermuda, Jamaica, Barbados and Hawaii. No travel to the Far East yet. Anyone?

For the last seven years I have been helping companies move their data from Lotus Notes to the Microsoft platform.

Some thoughts on Notes to Exchange Migrations
Migrating from Lotus Notes to Microsoft - Very easy and very hard
Pre- Migration Report that I use
Encrypted Mail Choices
Export a Notes View to CSV
Mail Migrations Using the Cloud
Mail Migrations - Some Lessons Learned
Speeding Some Migrations
Redirecting Mail Migration Traffic
One post migration story
One Approach to Mail Rules
Remove Encryption Button
Microsoft's "Secret" Mail Migration Tool
NME Migrations from a secondary Domino Directory
How to remove encryption from a Notes database
NME and Secondary Address Book
Multi File Selector for Binary Tree CMTe
Problem Mail Files for NME (Notes Migrator for Exchange)
Using a Staging Server for Notes to Exchange migrations
SmartCloud to Office 365
Notes2SharePoint Part 1
Migrating Private Folders
Different roles in an email migrations
What to do with Profile Docs during a Migration

If you would like to see my resume
Click Here

Email John

Copyright 1999-2019, John Vanderhoff. All rights reserved. This document is NOT in the public domain and remains the property of John Vanderhoff. Distribution or modification of this document without the knowledge, review and express permission of John Vanderhoff is strictly prohibited.