Ecora Auditor: Microsoft SQL Sample Reports

Back to Report Gallery

  • Documentation Report
  • Baseline Report
  • Change Report
  • Fact Finding Reports:
    • Basic Database Information – Reports Basic Database information including instance, database name, version, compatibility, and creator.
    • Basic Instance Information – Reports Basic Instance information including instance, version, operating system, and memory.
    • Logins With No Password – Reports a list of SQL logins that have blank or null passwords for each instance. Useful for an “at-a-glance” look for potential security gaps.
    • User Database Access – Reports a list of databases and basic access for each user.
    • User Server Access – Reports a list of instances and basic access for each user.
  • Consolidated Change Log Reports:
    • Database Maintenance Plans – Track the changes to your Database Maintenance Plans. This report shows additions and changes to:
      • Database Maintenance Plans
        • Databases included in the plan
        • Included Jobs
        • Target Servers
      • SQL Server Agent
        • Jobs
        • Job Steps
        • Job Schedules
    • Database Roles and Permissions – This trend report illustrates changes in database roles over time as well as databases that have been added or removed from the server.
    • Login Changes – This report shows Server Logins that have been added and removed from the server over time. In addition, the trend report shows how the values for each Login attribute have changed over time.
    • Server Roles – This simple report illustrates changes to the server roles, such as an addition to the SYSADMIN Server Role.
    • Server Settings – Track changes to your MS SQL server instance settings with this Report of changes to 47 SQL Server configuration and tuning parameters. This will aid you in troubleshooting performance problems or capacity planning.