How can I determine if all mail files have a corresponding person document?

HCL Domino Domino Forum
1

Hi there!

I have over 10,000 users. I am doing a cleanup and would like to know if there are some “orphan” mail files.

Does anyone know a way I can accomplish this?

Thanks!

2

Subject: How can I determine if all mail files have a corresponding person document?

From windows command line, locate your mail directory (I hope all mail files are in the same folder) and issue a

dir *.nsf /b > mailfilelist.txt

Then, create an agent that

  1. Reads the file you just created (mailfilelist.txt) into a list variable

  2. Iterates through the People view one document at a time and checks to see if the mail file filename IsMember(listMailFile…

  3. Delete any list element found.

  4. Remaining list elements are databases in the mail directory that don’t have an “owner” in the address book. These elements can either be written back to a file, or to a mail message (including doclinks if you want to go that far), etc.

3

Subject: RE: How can I determine if all mail files have a corresponding person document?

Thanks so much, Cesar!

This is a great approach.

Have a good weekend!

Gérald