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:

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.
—Rob...

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Server How to move Notes databases off Domino 8 servers and save disk space Move a Lotus Domino server to a new certifier without a reinstall Securely connect Lotus Domino servers on different domains Track and record Lotus Notes user logins to Domino Server Use SMTP outbound authentication to relay hosts in Lotus Notes Domino 8 Log off idle Lotus Notes users for better Domino Server performance Copy Lotus Notes databases from the Domino Server console command line How to perform an in-place upgrade of Lotus Domino server hardware Daylight Saving Time 2007 -- seven helpful tips for Lotus Notes administrators FileZilla Lotus Notes Domino Mailbox Management Secure Lotus Notes/Domino 8.x from mail to unknown recipients Run or restart Notes/Domino agents via text messages How to create mail files using a LotusScript agent How to turn off the message recall feature in Lotus Notes 8 Domino server setting and email policy tricks admins must know Customize the principal field of outgoing email messages LotusScript action button manages Lotus Notes mail files JavaScript error encountered when opening Lotus Notes email Bringing MailRule documents back into view LotusScript agent moves tagged spam email to junk mail folder

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

ert 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.

Rate this Tip To rate tips, you must be a member of SearchDomino.com. Register now to start rating these tips. Log in if you are already a member. 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.