0 pts.
 Domino Database Last Used
Does anyone have any tools they developed to search all the databases on a server(s) and report on them based on the last modified or created date? Or even point me in the correct direction. I am a rookie. Thanks.

Software/Hardware used:
ASKED: March 9, 2005  7:36 AM
UPDATED: March 9, 2005  9:28 AM

Answer Wiki:
If the database is marked to be listed in the domain catalog (database properties) then the Domain Catalog will show the creationdate, last modified and activity along with alot of useful info. The activiy includes changes from scheduled agents.
Last Wiki Answer Submitted:  March 9, 2005  7:49 am  by  Brucelill   295 pts.
All Answer Wiki Contributors:  Brucelill   295 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

The domain catalog – catalog.nsf – has hidden views you can use to troll through the databases (more precisely, the database listings) in the catalog. The one I usually use is($ReplicaID). If you go open the catalog, hold CTR+SHIFT and choose View | Open you will see a list of all the views including the hidden ones. (A hidden view is one whose name is in parentheses.) The documents in that view contains items describing the properties of the database in question.

(Of course, if a database isn’t listed in the catalog you won’t find it this way, so keep that in mind. An alternative would be to use the NotesDbDirectory class in LotusScript.)

A lotusscript agent to troll through the ($ReplicaID) view checking certain values on each database would go roughtly as follows:

Instantiate a NotesViewNavigator from the ($ReplicaID) view, then get the first entry. This will be a category. Get the first entry under that category; create a second notesviewnavigator from that category value – use CreateViewNavFromCatgory – and get the first entry in that navigator. This will be the first document in that category. (Documents are categorized by replica id, so you only need the first one in each category.) Check the item values you want, then call .getNextCategory() on the first navigator. Rinse, repeat.

 0 pts.