If you select the Process gathered events option on the Select Task page, the Collector wizard displays the Data Processing Task page on the next step.
On the Data Processing Task page, the wizard prompts you to specify what you want to do with the events that were gathered from the Administration Service computers and stored in the database. You can choose one of the following options:
- Export using date range: Specify the date range for the events you want to export. The time you specify is considered Greenwich Mean Time (GMT).
- Export events older than: Specify the age limit for the events you want to export.
- Delete events older than: Specify the age limit for the events you want to delete.
Click Next to proceed to the Source database page, allowing you to specify the database from which you want to export or delete information. Click the button next to the Database field. In the dialog box that appears, you can specify the database you need, and the authentication option for connecting to the SQL Server.
When finished, click Next to continue.
If you have chosen the option to export information, the wizard displays the Target Database page prompting you to specify the database to which you want to export information. Click the button next to the Database field. In the dialog box that appears, you can specify the database you need, and the authentication option for connecting to the SQL Server.
When finished, click Next to start the operation.
While the wizard performs the operation you selected, you can see the progress screen, showing you the progress details. When the operation is completed, the wizard displays the final screen that shows you the operation results. You can click View Log to examine the operation log for possible errors.
To process the gathered events, start the Collector wizard (see Starting the Active Roles Collector wizard), and complete the wizard pages as follows.
-
On the Select Task page, select the Process gathered events option.
-
On the Data Processing Task page, specify what you want to do with the events that were gathered from the Administration Service computers and stored in the database. Select one of the following options:
- Export using date range: Specify the date range for the events you want to export. The time you specify is considered Greenwich Mean Time (GMT).
- Export events older than: Specify the age limit for the events you want to export.
- Delete events older than: Specify the age limit for the events you want to delete.
-
On to the Source database page, click Specify, and enter the name and SQL Server of the database from which you want to export or delete the events. You can also choose the authentication option for connection to SQL Server.
-
On to the Target Database page, click Specify box, and enter the name and SQL Server of the database to which you want to export the events. You can also choose the authentication option for connection to SQL Server.
The new version of the Active Roles reports is incompatible with the database of an earlier Collector version. To create reports based on the events held in that database, you need to import the events to the database of the new Collector version, and then specify the database of the new Collector version as the data source for the reports of the new Report Pack version. For more information,, see Configuring the data source.
To import events from the database of an earlier Collector version, start the Collector wizard, and complete the wizard pages as follows. For more information, see Starting the Active Roles Collector wizard.
-
On the Select Task page, select the Import events from an earlier database version option.
-
On the Source database page, click Specify, and supply the name, database type, and SQL database server used by your Collector of an earlier version. You can also choose the authentication option for connection to SQL Server.
-
On the Target Database page, click Specify, and supply the name, database type, and database server of the database used by your Collector of the current version. You can also choose the authentication option for connection to SQL Server.
Active Roles reports require Microsoft SQL Server Reporting Services (SSRS). Make sure that you have SSRS in your environment. To use Active Roles reports, you first need to deploy them to your SSRS Report Server by using the Collector wizard.
To deploy the Active Roles reports to the Report Server, start the Collector wizard, and complete the wizard pages as follows. For more information, see Starting the Active Roles Collector wizard.
-
On the Select Task page, select the Deploy reports to Report Server option.
-
On the Report Server page, type the URL of your SSRS Report Server in the Report Server Web Service URL box.
By default, the URL is http://<serverName>/ReportServer.
-
(Optional) On the Data Source page, configure the data source for the Active Roles reports:
-
Click Configure Data Source.
-
Use the Configure Data Source dialog to specify the Database Server instance that hosts the database you have prepared by using Collector, the name of the database type, and the authentication method to use for connection to the database.
Configuring the data source is an optional step. If you do not have a database prepared by Collector, you can configure the data source later, after you have deployed the reports. For more information, see Configuring the data source.
Once you have deployed the reports to your SSRS Report Server and configured the data source, you can create and view Active Roles reports using Report Manager, a web-based tool included with SSRS. For more information, see Generating and viewing a report.