How to install and configure DRA Reporting

NetIQ Directory Resource Administrator (DRA) provides an optional reporting feature. This reporting uses the NetIQ Reporting Center (NRC) console to view data gathered by DRA Reporting Service Collectors. DRA Reporting Services provides summary data for the following features:

• Active Directory (AD) Domain objects for all domains managed by DRA
• Microsoft Exchange Configuration
• Network Resource Details for all Network resources within any domain managed by DRA
• DRA Security Configuration
• DRA Operation Summary
• DRA Operation Count

Determine which DRA Reporting components to install on which servers

1. NetIQ Reporting Center Setup (NRCSetup.exe)
   1. Configuration Database -- Used to store Security and Configuration data for the NRC Console. This can be installed remotely to a SQL Server. This requires local or remote access to a Microsoft SQL Server
      
   2. Web Service -- This is a Windows Internet Information Services application pool used by the NRC Console to connect to SQL. This Requires Windows IIS to be installed. This only installed on one server.
      
   3. NRC Console -- This is the console used to view the data gathered by the DRA Reporting Services collectors. This can be installed on multiple Servers or workstations.
   4. Reporting Services Data Extensions -- These are used by the NRC console to export data for viewing outside of the NRC Console. This must be installed locally on a SQL Server hosting SQL Server Reporting Services. This SQL Server must also host the NRC configuration database (NQRConfig)
      
2. DRA Reporting (DRAReporting.MSI)
   1. This must be run locally on the same SQL Server hosting the NRC configuration database (NQRConfig)
      1. The SQL Server must also be hosting SQL Server Integration Services
      2. The SQL Server agent must be set to run automatically and started
      3. The SQL Server agent must be running as Local System
         
   2. This will install both the SMCubeDepot and DRAReporting databases
   3. This will install both the DRA Datapump and DRA Aggregations  SQL Server Integration Services jobs
      1. Each job has a default schedule predefined
      2. Each job can be enabled or disabled by using SQL Management Studio
         1. If the job is disabled, there will be red x or circle on the job icon.
3. Configure DRA Reporting Services
4. Launch the Delegation and Configuration Console in the context of the DRA Service account or other account with DRA Administration Rights
   1. Ensure the D&C console connects to the Primary DRA Server
5. Within the D&C console highlight the Configuration Node
   1. Within the right hand pane of the configuration node click the Update Reporting Services Configuration
6. From the DRA Reporting Services enable and configure DRA
   
   1. Placing a Check in the box for Enable DRA Reporting Support unlocks the Reporting Services Configuration
      1. The Credentials section specifies the working credentials used to interact with SQL when the Reporting Service Collectors are running
      2. The Admin Credentials section specifies the credentials used to create the structure and initial content of the DRA Reporting Database
         1. It is possible to have these credentials match what is currently configured on the NetIQ Administration Service
         2. It is possible to manually type a specific user ID and password
         3. It is possible to have both the credentials and admin credentials be the same account
   2. The Active Directory Collector allows for configuration of the AD and Resource collector for each domain managed by DRA
   3. The DRA Collector allows for configuration of the DRA configuration and Exchange configuration collector
   4. The Management Report Collector allows for the DRA activity data summary collection
   5. The Collector Status shows the status of the DRA Reporting Service Collector jobs
      

DRA Reporting Services is an optional feature of DRA. This feature must be installed and configured in addition to the DRA Server and Console install.

Additional details about DRA Reporting can be found in the online documentation for DRA. The initial install of both NRC and DRA Reporting will require full sysadmin role within SQL.