Generating and Viewing Database Reports for Enterprise Pools

Topic Last Modified: 2009-03-06

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

Table 1. Database Reports

Section	Description
General Settings	This section displays the name of the back-end database used by the selected pool.
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 R2. 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 the total number of participants.

Each of these reports is available from the Database tab. The tab also contains the name of the database where the information is stored. Use the following procedure to generate and view a database report.

To generate and view a database report

1. Open the Office Communications Server 2007 R2 snap-in.

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.

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 user’s 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.