Chat now with support
Chat with Support

Active Roles 7.2 - Evaluator Guide

Introduction Test lab setup Managing users and groups Delegating administration Using Managed Units Using Active Roles policies Managing Exchange recipients Managing permissions in Active Directory Using dynamic groups Delegating computer resource management Using audit trail and reporting Using Active Roes replication Customizing the Web Interface

Use reports to analyze the audit trail

Using audit trail and reporting > Analyze the Audit Trail > Use reports to analyze the audit trail

The Work with Active Roles reports section later in this document provides information on how to use reporting in Active Roles. The many reports you can prepare include special reports that are based on the Active Roles audit trail. Some examples are as follows.

Work with Active Roles reports

Using audit trail and reporting > Work with Active Roles reports

Work with Active Roles reports

Active Roles comes with a rich suite of reports—Active Roles Report Pack. Active Roles reports cover all administrative actions that can be taken with this product. To create and view reports, you must install Active Roles Collector and Active Roles Report Pack. If you install Active Roles as described in the section Installing the reporting components earlier in this document, you have installed all components required to work with Active Roles reports.

Collect data for reporting

To prepare reports, you first need to collect data for reporting.

To collect data for reporting

  1. Open the Active Roles Collector wizard by selecting Active Roles Active Roles Collector on the Apps page or Start menu, depending upon the version of your Windows operating system.
  2. On the Welcome page, click Next.
  3. On the Select Task page, select the option Collect data from the network. Click Next.
  4. Click Browse and complete the SQL Server Connection wizard as follows.

    You only need to complete the SQL Server Connection wizard once, when using the Collector wizard for the first time.

  1. On the SQL Server page, click Use SQL Server authentication, and set the other options as follows:
    1. In the Server box, enter <ServerName>\sqlexpress, replacing <ServerName> with the name of the computer on which you installed SQL Server Express.
    2. In the Logon Name box, type sa.
    3. In the Password box, type the password for the sa login.
  2. Click Next.
  3. On the Select database page, in the Database box, type ARServerReporting.

    The wizard will create a database with the name you specify. It is advisable to create a new database rather than select an existing database. If you select an existing database, the data in that database may be corrupted during the data collection process.

  1. In the Configure Data Source dialog box, review the settings you have specified, and then click OK.
  2. In the Active Roles Service box, type the name of the computer running the Administration Service.
  3. Select the Current User option (assuming that you are logged on as an administrator of that computer).
  4. Click Next.
  5. On the Data Collection Tasks page, in the Collect box, select all check boxes. Click Next.
  6. On the Data to Collect page, in the Collect box, select all check boxes. Click Next.
  7. On the Select Domains or OUs page, click Add and select your test domain. Click Next.
  8. On the Select Operation Mode page, select the Now option. Click Next.
  9. Wait while the wizard collects data for reporting.
  10. Click Finish to close the wizard.

Generate and view reports

After the data for reporting is collected, you need to configure the data source for the Active Roles Report Pack to connect to the database where you have collected data for reporting.

To configure the data source

  1. Start SSRS Report Manager from your Web browser.

    Report Manager is installed during setup of SQL Server Reporting Services (SSRS) on the same computer as the report server. To start Report Manager, open Internet Explorer, and then, in the address bar of the Web browser, type the Report Manager URL. By default, the URL is http://<ComputerName>/reports.

  1. Perform the following steps on the Contents page that appears:
    1. Click Details View.
    2. Click Active Roles.
    3. Click SharedDataSources.
    4. Click the data source named Active Roles 7.2 Report Data.
  2. In the Connection string box on the Properties page that appears, specify the SQL Server instance and the name of the database that holds the report data prepared by the Active Roles Collector.

    For example, if the name of the database is ARServerReporting and the database is on the SQL Server instance named MyServer\sqlexpress, then the connection string is as follows:

    data source = MyServer\sqlexpress initial catalog = ARServerReporting

  1. Click Apply.

Once you have configured the data source, you can use Report Manager to generate and view reports.

To generate and view reports

  1. In Report Manager, at the top of the window, click Active Roles.
  2. Perform the following steps on the Contents page that appears:
    1. Click 7.2.
    2. Click the folder containing a report you want to prepare.
    3. Click the name of the report.
  3. Wait while the Report Manager generates the report.
Related Documents