Notice: quest.com will be retired soon. Please visit our new site at software.dell.com

Enterprise Reporter for SQL Server

Enhance database security with SQL Server discovery, reporting and change history auditing

Gain visibility into Microsoft SQL Server database security configuration with Dell Enterprise Reporter for SQL Server. Gain a clear view and create ad-hoc reports on users and logins, roles and database permissions.

Easily execute change audits, security assessments and pre-and post-migration analysis. Gain the valuable insight you need for strategic planning and proactive management of your IT infrastructure.

Features

  • Ensure security visibility and compliance: Gain a clear view of critical SQL server configurations and permissions to comply with security best practices, internal policies and external regulations, boosting database security.
  • Capture change history: View detailed change history reports and get historical configuration information on database objects. Historical analysis and compliance reporting provides you with in-depth insight.
  • Generate permission reports: Create comprehensive reports on permissions to SQL databases, users, roles and logins.
  • Scale to AD environments: Scale to SQL Server environments of any size with scalable data collection capabilities. Minimize the impact of data collection on network and server performance, and leverage distributed collection architecture for load balancing by scheduling collections during off-peak hours.
  • Make storage more efficient: Compare SQL Server discoveries and store only changes, reducing database storage requirements and saving more change history data.
  • Boost auditing efficiency with separation of duties (SoD): Provide auditors, help-desk staff and IT managers only the reports they request, ensuring secure and effective audits aligned with department and business functions.
  • Customize reports: Create predefined and customizable reports with advanced filtering and multiple formats, including text and images in PDF, HTML, MHT, RTF, XLS, XLSX, CSV formats. Create customized reports with added attributes and advanced filtering for easy SQL Server ad-hoc reporting. This enables effective data analysis that meets the unique informational needs of your organization.
  • Automate reporting workflows: Automate report generation and delivery for multiple recipients and based on their schedules.
  • Standardized reporting portal: Gain a unified reporting interface across the entire family of Dell Software compliance and IT governance solutions by exporting reports to the Dell Software Knowledge Portal.

Sys Reqs

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.

Videos