Enterprise Reporter

Enterprise visibility, auditing and reporting for Active Directory, Windows Server and SQL Server

Enterprise Reporter is a scalable solution for auditing, analyzing and reporting on the configuration of Microsoft Active Directory, Windows Server and SQL Server across the enterprise.

Enterprise Reporter is a scalable solution for auditing, analyzing and reporting on the configuration of Microsoft® Active Directory®, Windows Server® and SQL Server® across the enterprise.

Predefined and customizable reporting tools make it easy to perform compliance and security assessments, pre- and post-migration analysis and configuration change history auditing—enabling successful IT audits, informed strategic planning and proactive management for Microsoft® Windows-based networks.

Features

  • Compliance & security visibility—Gain visibility into the configuration of all critical IT assets in Active Directory domains, SQL servers, Windows file servers and NAS devices. This comprehensive Windows server reporting improves compliance with security best practices, internal policies and external regulations.
  • Real-time access assessment—Know who has access to what resources across the enterprise network. Tighten security and ensure successful IT audits by ensuring that access is provided on a “need to know” basis.
  • Pre-migration and post-migration analysis—Ensure a smooth domain migration or consolidation project by inventorying what needs to be migrated and verifying that migrations are completed as planned.
  • Change review—Implement change review process by capturing the historical configuration of Active Directory, Windows file servers and SQL Servers, and viewing detailed change history reports.
  • Scalable data collection—Scale to environments of any size and geographic distribution. Schedule collections during off-peak hours to minimize the impact of data collection on network and server performance, and leverage a distributed collection architecture for load balancing.
  • Efficient storage—Reduce database storage requirements and save more change history data by comparing discoveries and storing only the changes.
  • Automated reporting workflows—Automate report generation and delivery for multiple report consumers according to different schedules.
  • Separation of duties (SoD)—Honor departmental and business function boundaries by letting auditors, help desk and IT managers get exactly the reports they asked for, including Active Directory reports.
  • Customizable reports—Use predefined and customizable reports with advanced filtering and multiple formats (including PDF, HTML, MHT, RTF, XLS, XLSX, CSV, text and images) to enable effective data analysis that meets the unique informational needs of your organization.
  • Common reporting portal—Export reports to Dell Knowledge Portal for a unified reporting interface across the entire family of Dell Software compliance and IT governance solutions.

Specifications

Before installing Enterprise Reporter, ensure your system meets the following minimum hardware and software requirements.

CPU

Intel or AMD 2 GHz multiprocessor
32 or 64-bit processors

RAM

Minimum: 4 GB RAM
Recommended: 8 GB RAM

Hard Disk Space

Disk space requirements will vary with the Quest Enterprise Reporter components you install:
Server—10 GB
Configuration Manager—10 GB
Discovery Node—10 GB for installed files, plus extra space for processing discoveries. Space required varies with the amount of data collected.
Report Manager—10 GB
Database size varies with the amount of data you collect.
The file share that you use for the Shared Data Location will require space for storage of collected data. Space required varies with the amount of data collected.
Total disk size if all components are on the same system—100 GB

Operating System

It is not recommended that the server or console be installed on a domain controller.

Server – Enterprise Reporter Server

  • Windows 2012 and Windows 2012 R2
  • Windows Server Core 2012
  • Windows Server 2008 R2 with Service Pack 1
  • Windows Server Core 2008 R2 wih Service Pack 1
  • Windows Server 2008 with Service Pack 2 (64 bit and 32 bit)
  • Windows Server 2003 with Service Pack 2 (64 bit and 32 bit)
  • Windows Server 2003 R2 with Service Pack 2 (64 bit)

Consoles – Configuration Manager, Report Manager and Database Wizard

  • Windows 2012 and Windows 2012 R2
  • Windows Server 2008 R2 with Service Pack 1
  • Windows Server 2008 with Service Pack 2 (64 bit and 32 bit)
  • Windows Server 2003 with Service Pack 2 (64 bit and 32 bit)
  • Windows Server 2003 R2 with Service Pack 2 (64 bit)
  • Windows 8.1
  • Windows 8 (64 bit and 32 bit)
  • Windows 7 with Service Pack 1 (64 bit and 32 bit)
  • Windows Vista with Service Pack 2 (64 bit and 32 bit)
  • Windows XP Professional with Service Pack 3 (64 bit and 32 bit) 
    (both components except nodes)

Discovery Targets

  • Windows Server 2012 and 2012 R2
  • Windows Server Core 2012
  • Windows Server 2008 R2 with Service Pack 1
  • Windows Server Core 2008 R2 with Service Pack 1 (64 bit)
  • Windows Server 2008 with Service Pack 2 (64 bit and 32 bit)
  • Windows Server 2003 with Service Pack 2 (64 bit and 32 bit)
  • Windows Server 2003 R2 with Service Pack 2 (64 bit)
  • Windows 8.1
  • Windows 8 (64 bit and 32 bit)
  • NetApp Filer - Data ONTAP 7.3.4 and Data ONTAP 8.0.1
  • EMC Celerra Storage Devices - EMC Celerra 5.6 with Server Message Block 1.0
  • Dell Fluid FS7600
  • Windows 7 with Service Pack 1 (64 bit and 32 bit)
  • Windows Vista with Service Pack 2 (64 bit and 32 bit)
  • Windows XP Professional with Service Pack 3 (64 bit and 32 bit)

Managed Computers

  • Windows Servers
    • Windows Server 2012 and 2012 R2
    • Windows Server Core 2012
    • Windows Server 2008 R2 with Service Pack 1
    • Windows Server Core 2008 R2 with Service Pack 1 (64 bit)
    • Windows Server 2008 with Service Pack 2 (64 bit and 32 bit)
    • Windows Server 2003 with Service Pack 2 (64 bit and 32 bit)
    • Windows Server 2003 R2 with Service Pack 2 (64 bit)
  • Clusters
    • Windows Server 2012 and 2012 R2
    • Windows Server Core 2012
    • Windows Server 2008 R2 with Service Pack 1
    • Windows Server Core 2008 R2 with Service Pack 1 (64 bit)
    • Windows Server 2008 with Service Pack 2 (64 bit and 32 bit)
  • Network Attached Storage (NAS) devices
    • NetApp Filer 7.3.4
    • NetApp Filer 8.0.1
    • Dell FluidFS FS7600
    • EMC VNX:7.0.35-3
    • EMC Celera 5.6.48
    • NetApp Release 8.1X47 7-Mode

Required Software

To obtain links to the following required software, launch the Enterprise Reporter Autorun. 
Microsoft.NET Framework 3.5 Service Pack 1
Microsoft.NET Framework 4.0 (Full) 
Microsoft Visual C++ 2005 Service Pack 1 Redistributable Package (x86) version 8.0.59193 
Microsoft Visual C++ 2005 Service Pack 1 Redistributable Package (x64) version 8.0.59192 
Microsoft Visual C++ 2010 Service Pack 1  Redistributable Package (x86) version 10.0.40219 
Microsoft Visual C++ 2010 Service Pack 1  Redistributable Package (x64) version 10.0.40219 
Microsoft Visual C++ 2012 Service Pack 1 Redistributable Package (x86) version 11.0.60610.1
Microsoft Visual C++ 2012 Service Pack 1 Redistributable Package (x64) version 11.0.60610.1

Required Services

Remote Registry service enabled on discovery targets for collections

SQL Server
Requirements

SQL Server 2005 Service Pack 3
SQL Server 2005 Express Service Pack 3
SQL Server 2008 Service Pack 2
SQL Server 2008 R2
SQL Server 2012
SQL clusters and database mirroring are supported for your deployment, including SQL Server 2012 Always On. Databases hosted on clusters cannot be discovery targets.

Access Explorer
Agent Service
Requirements

500 MHz+ Processor
Minimum 2 GB RAM; Recommended 4 GB RAM
100 MB free disk space for every 1,000,000 files/folders scanned

Windows clusters and NAS devices need to be managed by a remote agent, located on a machine running a Windows O/S that is supported by Enterprise Reporter.

When an agent service is installed on Windows Server 2012, you must disable the following local policy: User Account Control: run all Administrators in Admin Approval Mode.