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
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.