I need to pull up list of users per server along with their mail file SIZE.
Please advise how to pull up the data and export it to Excel
Subject: Try this
On each server, use the methods GetFirstDatabase() and GetNextDatabase() in the NotesDbDirectory class to get all databases on the server.
For each database, check if it is located in /Mail (assiming that is where you put the mail files), if so you can get the size of the .nsf in bytes by using the db.Size.
The helpfile got nice sample code, look under GetNextDatabase() for a good one.
Subject: Export to Excel
I forgot, in order to export the data to Excel, just create a CSV file. Or you could create a file containing a HTML table, but naming it .xls will make Excel opening it as a spreadsheet.
Subject: I don’t know programming
Can you please explain the steps in great details, I have never worked with codes.
Thanks
Subject: I can write you the code…
If your company does not have a programmer, contact me at texasswede@gmail.com and we can discuss exactly what you need. I need more information about things like how many servers you have (if the mail files are split over multiple servers), if all mail files are in the /mail folder, etc.
When I know that I can give you an estimate of how long it will take me. Should not be very complicated, a couple of hours of coding and testing.
Subject: Solution (Very Easy)
It works only if you have notes client version 8.5 and later.
Go to Admin Client - Files - mail
Copy all and paste it to Excel
Thats it !!!
Subject: Wrong forum then…
You posted in teh Notes 8 forum, and you specified that you have 8.0.1.
You really should post in the correct forum, and specify the correct version, that way we know what capabilities you have…
Subject: Version
It works with R8.5 and later
Thanks for your time !