• Article

Generating and Viewing Database Reports for Enterprise Pools

Microsoft Office Communications Server 2007 and Microsoft Office Communications Server 2007 R2 will reach end of support on January 9, 2018. To stay supported, you will need to upgrade. For more information, see Resources to help you upgrade your Office 2007 servers and clients.

For each Enterprise pool, you can use the Database tab to view the database name, as well as retrieve and view reports from the database. Table 4 describes the reports that are available for each Enterprise pool.

Table 4. Database Reports

Section Description

User Summary Reports

This section displays aggregate information about users in a pool, such as the number of enabled users, the average number of contacts per user, and the number of users for specific features.

When you use these reports, the following information may be helpful:

  • An enabled user is a user who has been enabled for Office Communications Server 2007 by using the Active Directory Users and Computers snap-in.

  • An active user is a user who has logged on or registered.

  • The summary reports also offer a set of statistical information regarding contacts. These statistics are only valid for the population of users who have logged on at least once and who have at least one contact. Consequently, you will typically not see a minimum number of contacts of 0. Because of this behavior, if a user has no contacts (but is active, in that the user has registered), you may see <empty> for some of the statistics fields.

Per-User Reports

Unlike the summary reports, which are calculated over a user population, these are reports about a specific user.

Conference Summary Reports

This section displays aggregate information about conference summary statistics for the pool, such as the number of active conferences and total number of participants.

Each of these reports, as well as the name of the database where the information is stored, are available from the Database tab. Use the following procedure to generate and view a database report.

To generate and view a database report

  1. Open Office Communications Server 2007.

  2. In the console tree, expand the Forest node, expand Enterprise pools, and then click the pool for which you want to generate a database report.

  3. In the details pane, click the Database tab.

    a9eb62b8-b5e3-4dbd-b7ae-7879663d1835

  4. On the Database tab, do the following:

    • To view the name of the database, expand General Settings, and then view the database name.

    • To retrieve current user summary statistics for the pool, expand User Summary Reports, click Go, and then view the results.

    • To retrieve current per-user data for an individual user of the pool, expand Per-User Reports, type the users SIP URI, click Go, and then view the results.

    • To retrieve current conference summary statistics for the pool, expand Conference Summary Reports, click Go, and then view the results.