Tip

Capture mailbox database size and export to Excel

View member feedback to this tip.

Do you have a limit on mailbox database size? Have you ever wondered how you could quickly find out the size of all the databases, and then put the data into Excel?

  1. Make a directory and call it BATCH.
  2. Put the code attachment in a file called sizelist.bat.
  3. Map a drive (call it 'O' here) to the volume on your Domino server mapped to the mail directory.
  4. The file dump will consist of a directory listing of the files *.nsf (in all subdirectories) using lowercase and new-long-list format.
  5. You can easily drop this into Excel and use a data/text2columns action.
  6. Then just send a witty e-mail to the users with mailboxes over their limit.

The code is:

  
c:
cd batch
md batchtemp
o:
dir *.nsf /o:s /s /l /n >> 
c:\batch\tempsizelist.txt 
c:

You can even run this fix on a local PC rather than the server.

MEMBER FEEDBACK TO THIS TIP

What's wrong with the Admin client? Under the Files tab choose Mail, then you can find some valuable information.
—Max L.

******************************************

This tip was written to support administrators who don't have access to the Admin client. Some companies (like mine) do not permit IT staff of or below a certain level to access the Domino Admin client. Hence, writing the batch file was of use to my staff.
—Mike Bird, tip author

******************************************

This will only work against Intel-based mail servers or clients. This tip should include a disclaimer about that.
—Steve H.

******************************************

Can we get this for OS/400, Linux, or AiX too? We all don't run Windows Server...because we are smarter than that!
—Davis V.

******************************************

Can the equivalent be done in z/OS (which is Unix based) Domino? We have 9 z/OS Domino servers so Wintel-based tips don't help me.
—Robert S.

******************************************

Unfortunately, my knowledge of Unix/Linux is patchy. I'm sure any Unix Admin could code an equivalent using the 'ls' command. The same goes for Aix/AS400 and Z/OS where I am completely unfamiliar with the Operating System.
—Mike Bird, tip author

******************************************

This tip is fine, but there also is a Domino way to do this. Our e-mail files are on an AS400, so this tip would not work for us. This method will work for everyone (I think).

  1. Go to the server log where the e-mail files are.
  2. Go to the Usage/By Size view
  3. Execute File/Export; then select a Path/Filename (say A.WK4) and pick a type of Lotus 1-2-3.
  4. In the pop-up box select All Docs and Include View Titles.

This will create a spreadsheet file that you can open in Excel. Please note that the WK4 is important to avoid extra termination characters in each cell.
—Bob L.

******************************************

Be very careful about permissions when mapping drives containing Domino data files. Anyone able to 'see' the drive will be able to access the Domino files as if they are on a 'local' server and thus circumvent most of the built-in Domino security.
—Peter T.

Do you have comments on this tip? Let us know.

This tip was submitted to the SearchDomino.com tip exchange by member Mike Bird. Please let others know how useful it is via the rating scale below. Do you have a useful Notes/Domino tip or code to share? Submit it to our monthly tip contest and you could win a prize and a spot in our Hall of Fame.

This was first published in September 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.