Skip to content

What's Documented

Jump to bottom
SheepReaper edited this page Jun 24, 2017 · 1 revision

What's Documented

SQL Power Doc collects an exhaustive set of information about SQL Server instances and their underlying Windows OS. SQL What's collected depends on the version and edition of SQL Server, version and edition of Windows, and runtime parameters.

Here's everything SQL Power Doc can document:

SQL Sever Services

  • Service Details for all installed SQL Server services

Database Engine

Configuration

  • General Details
  • Memory
  • Processors
  • Security
  • Connections
  • Database Settings
  • Advanced Settings
  • High Availability (Clustering & AlwaysOn)

Security

  • Logins
  • Roles
  • Credentials
  • Audits
  • Audit Specifications

Server Objects

  • Endpoints
  • Linked Servers
  • Startup Procedures
  • Server Triggers

Server Management

  • Resource Governor
  • SQL Trace
  • Trace Flags
  • Database Mail
    • Accounts
    • Profiles
    • Security
    • Configuration

Databases

  • Configuration
    • General Details
    • Files
    • Filegroups
    • Options
    • Change Tracking
    • Permissions
    • Mirroring
    • AlwaysOn
  • Database Objects
    • Tables (Properties, Checks, Columns, Foreign Keys, Full Text Indexes, Indexes, Statistics, Triggers)
    • Views (Properties, Columns, Full Text Indexes, Indexes, Statistics, Triggers, Definition)
    • Synonyms (Properties, Definition)
    • Programmability
      • Stored Procedures (Properties, Parameters, Definition)
      • Extended Stored Procedures (Properties)
      • Functions (Properties, Checks, Columns, Indexes, Parameters, Definition)
      • Database Triggers (Properties, Definition)
      • Assemblies
      • Types
        • User Defined Aggregates (Properties, Parameters)
        • User Defined Data Types (Properties)
        • User Defined Table Types (Properties, Checks, Columns, Indexes)
        • User Defined Types (Properties)
        • XML Schema Collections (Properties, Definition)
        • Rules (Properties, Definition)
        • Defaults (Properties, Definition)
        • Plan Guides (Properties, Definition)
        • Sequences (Properties)
  • Service Broker
    • Message Types
    • Service Contracts
    • Queues
    • Services
    • Routes
    • Remote Service Bindings
    • Priorities
  • Storage
    • Full Text Catalogs
    • Full Text Stop Lists
    • Partition Schemes
    • Partition Functions
  • Security
    • Users
    • Application Roles
    • Database Roles
    • Certificates
    • Schemas
    • Asymmetric Keys
    • Symmetric Keys

SQL Agent

Configuration

  • General Details
  • Advanced settings
  • Alert System
  • Job System
  • Connections
  • History

Jobs

  • General Details
  • Steps
  • Schedules
  • Alerts
  • Notifications

Alerts

  • General Details
  • Reponses
  • Options
  • History

Operators

  • General Details
  • Notifications
  • History

Windows OS

Machine Information

  • BIOS
  • Physical Memory
  • Processors
  • Sound Devices
  • System Enclosure
  • Network Adapters
  • Printers
  • CD\DVD Drives
  • Disk Drives
  • Tape Drives
  • Video Cards

OS Information

  • Time Zone
  • Event Logs
  • IPv4 Routes
  • Page Files
  • Registry Settings
  • OS Details
  • Power Plans
  • Startup Commands
  • Running Processes
  • Services
  • Shares
  • Local Users
  • Local Groups
  • Desktop Sessions

Software

  • Installed Applications
  • Patches

System Requirements

For Use

  • Windows PowerShell version 2.0 or higher (version 3 or higher strongly recommended)
  • SQL Server Management Objects (SMO)
  • Microsoft Excel 2007 or higher
  • Sysadmin level rights to SQL Server
  • Administrator level rights to Windows (Optional)
  • RDS-Manager PowerShell Module (Optional
Clone this wiki locally