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 an automated, scalable solution for auditing, analyzing and reporting on Microsoft® Active Directory®, Windows Server®, SQL Server® and file servers across the enterprise.

Predefined and customizable reporting tools make it easy to perform:

  • Compliance and security assessments
  • Pre- and post-migration analyses
  • File storage capacity planning and monitoring
  • Configuration change history auditing

Enable successful IT audits, informed strategic planning and proactive Microsoft® Windows-based network management.

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.
  • Storage analysis—Gain insights into file server storage capacity, storage growth rates, stale files, top storage offenders (by user or department), files taking up a disproportionate share of storage and more to aid in data cleanup, file server consolidations/migrations and storage policy enforcement.
  • 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.
  • InTrust IT Search integration—Use a single web console to find who has access to what and how that access is used. IT Search uses data collected by InTrust and Enterprise Reporter to consolidate configuration data (users, computers, files and folders) with event data (what users do) into a single, web console providing familiar search engine-like experience.

Specifications

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

CPU

Intel or AMD 2 GHz multiprocessor
64-bit processor (recommended) or 32-bit processor

RAM

Minimum: 8 GB RAM
Recommended: 12 GB RAM

Hard Disk Space

Disk space requirements will vary with the Enterprise Reporter components you install:
Server—10 GB
Configuration Manager—2 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 Server 2012 and Windows Server 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 Server 2012 and Windows Server 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)

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,  Data ONTAP 8.0.1, Data ONTAP 8.1 7-Mode, Data ONTAP 8.2 C-Mode
  • EMC Celerra Storage Devices - EMC Celerra 5.6 with Server Message Block 1.0, Celerra 6.0.36.4, Celerra 7.0.52.1
  • EMC VNX 7.0.35.3 and VNX 7.1.47.5
  • Isilon OneFS 7.1.0.0
  • Dell FluidFS7600
  • 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 Data ONTAP 7.3.4, 8.0.1, 8.1 7-Mode and 8.2 C-Mode
    • EMC Celerra 5.6 with Server Message Block 1.0, Celerra 6.0.36.4, Celerra 7.0.52.1
    • EMC VNX 7.0.35.3 and 7.1.47.5
    • Isilon OneFS 7.1.0.0
    • Dell FluidFS7600

NOTE: New Dynamic Access Control (DAC) features are not supported.

 

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
Microsoft Excel (required to view reports exported as spreadsheets)
Microsoft Excel 2010
Microsoft Excel 2013

 

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 Server 2014
SQL clusters and database mirroring are supported for your deployment, including SQL Server 2012 Always On.

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.

Upgrade and Compatibility

Note the following when upgrading to Enterprise Reporter 2.5:

  • Disable clusters to stop discoveries from being sent to the nodes.
  • Cancel any jobs running on the nodes to stop data from writing to the Enterprise Reporter database.
  • Create a backup of the database.
  • Note the port number being used by the Enterprise Reporter server.
  • Upgrade the Enterprise Reporter components.
  • Upgrade the nodes.
  • Manually upgrade any manually configured nodes.
  • Enable any disabled clusters to resume discoveries.
  • Upgrade the Access Explorer agents.

Note the following for compatibility:

  • When deploying the agent service to scan and index security information, consider agent services from Quest One Identity Manager Data Governance Edition and Quest Access Manager. Agent services from these products cannot coexist on the same agent computer. To scan the same scopes/targets from all of these products, ensure that different agent computers are used.

Resources