How can I export a list of databases resident on a given Domino server?

lotus-notes lotus-domino
Will Wagner picture Will Wagner · Nov 12, 2008 · Viewed 10.8k times · Source

I have a Lotus Domino server with a truly astounding number of Domino databases on it, arranged in various folders.

Is there some means of exporting a list of all these databases, with their titles and creators' names, in a spreadsheet format of some kind? I have the Domino Admin and Domino Designer software, and I have or can get whatever access rights I'd need.

Answer

Ed Schembor picture Ed Schembor · Jun 26, 2009

Actually, you can use a very simple Lotuscript agent to connect to a server and walk through all databases on the server, using the NotesDbDirectory class. Here is some code, modified slightly from what's in the 6.5 Help files - this dumps the title and path of all databases to a csv file. Note: the one argument to the GetFirstDatabase method let's you specify which objects on the server you want to scan - 1247 is the constant for "Databases" - basically, all NSF files. There are other constants for finding templates only (NTF's), only database with replication enabled, etc.

Sub Initialize
    Dim db As NotesDatabase
    Dim f As Integer
    f = Freefile
    Open "c:\dbExport.csv" For Output As #f

    Dim dbdir As New NotesDbDirectory("")  ' opens LOCAL - put a server name here
    Set db = dbdir.GetFirstDatabase(1247)  ' all databases - NSF, NSG and NSH (no templates)
    While Not(db Is Nothing)
        Print #f, """" + db.Title + """, """ + db.FileName + """"
        Set db = dbdir.GetNextDatabase
    Wend
    Close #f
End Sub

Related questions

How to export Rich Text fields as HTML from Notes with LotusScript?

I'm working on a data migration task, where I have to export a somewhat large Lotus Notes application into a blogging platform. My first task was to export the articles from Lotus Notes into CSV files. I created a Agent …

Read More
Lotusscript: From address when sending email as web user

I have a lotus-script agent which runs as Web User since I need to know who the current user is and process information accordingly. The problem is that when sending a email in this agent the From email address shows …

Read More
How do I select all documents from the last 7 days?

I have a view selection formula SELECT @If( @Date(@Now) = @Date(@Created); @All; @False) and I want it to select all documents from the past 7 days rather than just today's.

Read More