I’m am new to Domino administration and I am looking for a way to query Domino and output to a Spreadsheet. For instance list all users and their mail quota limits or mail file size etc. Can anyone help?
Subject: Query Domino
One way would be to use ODBC.
NotesSQL is a program that allows other programs to read the data stored in Notes Databases.
Technically, it’s an ODBC interface that allows SQL queries to access Documents and views as if they were SQL Tables and Views.
If you want to get a current copy, here’s the web site.
http://www.lotus.com/products/product4.nsf/wdocs/3243f3d81944584085256e20006db691)
(You may need to regester to get an ID “customer” ID before downloading - there’s no cost involved though.)
Subject: Query Domino
You can easily see all the users and their mail files through admin client.While Domino doesn’t provide a command to list such information.otherwise you can get the formatted information by writing lotusscript code.