Running a database analysis

A database analysis reveals changes in documents, user activity, and other details such as replication data.


  1. From the Domino® Administrator, select the server that stores the database you want to analyze.
  2. Click the Files tab.
  3. Select the folder containing the database you want to analyze.
  4. In the files window, select the database you want to analyze.
  5. In the Tools pane, select Database > Analyze.
  6. In the Analyze last x days of activity field, enter a number that represents how many days' worth of information to report. You can specify up to 99; the higher the number, the longer it takes to generate the results.
  7. Select one or more of the remaining options from the following table.
    Table 1. Database analysis options
    Option Reports
    Changes in: Data documents Details of document additions, edits, and deletions
    Changes in: Design documents Changes to the database ACL and design
    User activity: User reads Total times users opened documents in the database

    Total times servers read documents

    User activity: User writes Total times users and servers created, modified, or deleted documents

    Total number of mail messages delivered to the database

    Replication: Find replicas on other servers Data for other replicas
    Replication: Replication history Successful replications of a database as reported in the database replication history
    In logfile: Miscellaneous Events view Events relating to this database, as recorded in the Miscellaneous Events view of the log file
    In logfile: Database usage view Database activity, as recorded in the Usage > By User view of the log file
  8. Click Results, specify any of the following, then click OK.
    1. If allowed in the context, select one of the following options:
      Note: In some contexts, you make this choice in a preceding dialog box instead of in the Results Database dialog box.
      • Overwrite database – Deletes any existing results database and creates a new one.
      • Append to this database – Adds new results data to the database that was already specified.
    2. Select the server on which you want the results database to reside.
      Tip: It is recommended that you create the results database on a local client rather than on a server. If multiple people generate results databases on a server, they should each specify a different file name so the results do not conflict.
    3. Modify the database title if you do not want to use the default title.
    4. Modify the database filename if you do not want to use the default filename.
    5. If allowed in the context, click the folder icon to change the drive and/or directory in which the database is stored.
  9. Click OK to run the analysis.
  10. To see the results, open the database and choose one of the available views.
  11. Open Database Analysis Results documents in the selected view.