Scripts or View - Required ASAP (if poss)

We have just taken over the server admin of a couple of poorly managed notes servers.

I need to quickly find out a ilst of users, whose mail file is currently larger than a specific size (eg > 150Mb)
I can see the culprits in domino admin, but need to print a subsection of the list for a presentation.

My script writing techniques are very very rusty, can i be cheeky and ask on how I am quicky going to write this??

All I need is the mail file user / file name / database size....

Any help would be greatly appreciated
Who is Participating?
marilyngConnect With a Mentor Commented:

The catalog.nsf by databases>>by category>> Mail will list all mailfiles for the server including path/name.   Opening each document will show you a list of fields available, including database size.

Quickest way is to create a view in the catalog.nsf that shows the server, file, title (name of user), and add a column with database size.  You can also create a view that will categorize the mail files by size so you can locate the ones you need.

Then print the view..  no script needed.

Also, log.nsf for each server will list all database sizes and usage.

Let me know if this helps.

HemanthaKumarConnect With a Mentor Commented:
Indeed a good suggestion from Marilyng !

Also check this tool which is published in for collecting statistics of databases by directory.

Heman - thanks!! Sorry, been away for a bit.  How's it going?

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Well, things are OK. Running under tight schedule. And coping with EE race. I think, I have to retire from EE ;-)

SysExpertConnect With a Mentor Commented:
The fastest way is to open the Log file for a server , choose database - sizes.

This lists all the databases on the server by size.

Export it to a *.wk4 file and import it into Excel.

Format and clean it up, and you are all set !

I hope this helps !
Smile..Seems to be an echo in the message stream.

Second to last comment on my first post talks about the log.nsf file.  However, by itself, it doesn't show the full user name, as does the catalog.nsf.

Also, exporting to Excel as *.wk4 doesn't always work.  You end up with black box tabs at the end of each cell that you have to manually remove.  (extended ascii characters)

Best way to export (if you need to do this) is to export as "tabular text" and just NAME it as *.wk4.  This way when you open it in Excel, you can select and/or move the columns, and not have to worry about cleaning up stray ascii characters.  

If you have the ability to create a private view in the catalog.nsf, you can get both the format and information that you need that will print as a report without  having to export to excel.

Marilyn G
ZvonkoSystems architectCommented:
No comment has been added to this question in more than 765 days, so it is now classified as abandoned..
I will leave the following recommendation for this question in the Cleanup topic area:

RECOMMENDATION: split points between marilyng http:#6857701 and HemanthaKumar http:#6857887 and SysExpert http:#6859167

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

EE Cleanup Volunteer

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.