We use Quotas and Warning on our mail servers: Managers receive a Quota of 300M; other employees are allowed 50M.
We also use some of the Message Reports (Top 25 Users By Count, Top 25 Users By Size, Top 25 Largest Messages, etc.) Is it possible to create a report that will show the Top Users By Quota?
When I perform a Log Analysis on Error Code 0X0267 (“Warning. database has exceeded its warning size threshold of KB by <kb/gb>.”) the Log Analysis Results are pretty close to the information we are looking for.
If I can convert this information into a report that would be ideal.
Subject: Quota and Warnings Report
I was able to export data from the Database Sizes Analysis view to a spreadsheet and manually enter the Quota formula for each User’s account.
If anyone know how to automate this procedure I would appreciate it!
Subject: RE: Quota and Warnings Report
Here are instructions for creating the report. Enjoy!
From Domino Administrator
. Select Server, Analysis, Server’s Log, Database, Sizes view.
. File, Export, Save as type: Lotus 1-2-3 (*.wk1).
. 123 Worksheet Export: All documents and Include View titles.
From Microsoft Excel
. Open Lotus 1-2-3 file (*.wk?).
. The following View titles are available as columns: #, Database, Size KB, % Used, Weekly Usage.
. Add two columns: Quota KB, % Quota
. Manually enter the Quota for each User: Managers receive 300M; Employees receive 50M (Note: 1M = 1024K; 50M = 50*1024)
. Formula for % Quota = Size KB * (% Used / 100) / Quota KB
. Use Data Filter from Quota KB column to exclude NonBlank entries
. Select columns and Sort Data by % Quota
. Use the Chart Wizard to create a Bar Graph of the Top 25 Users by Quota