powershelldba.de · Uwe Janke

Live examples

Every sqmSQLTool HTML report, in one place.

49 report examples across 12 categories. Generated against a lab SQL Server instance seeded with the AdventureWorks sample database, read-only, no production or customer data.

Real report, actual output from a live run on the lab instance Illustrative example, this lab has no AlwaysOn AG / AD domain / second instance to run the command against, so values are representative

AlwaysOn

Get-sqmAlwaysOnHealthReportIllustrative Always On Health Report Replica synchronization, redo/send queue, and listener status for an availability group. View report → Compare-sqmAlwaysOnLoginsIllustrative AlwaysOn Login Comparison Login presence, SID and password-hash consistency across every AG replica. View report → Compare-sqmAlwaysOnRolesIllustrative AlwaysOn Server-Role Comparison Server-role membership (sysadmin, dbcreator, ...) compared across AG replicas. View report → Export-sqmAlwaysOnConfigurationIllustrative AlwaysOn Configuration Export Replica settings, listener configuration, and databases in the availability group. View report → Get-sqmAlwaysOnFailoverHistoryIllustrative AlwaysOn Failover History Failover events from the Windows Event Log and WSFC cluster log, classified as planned, automatic, or forced. View report →

Distributed AG

Get-sqmDistributedAgHealthIllustrative Distributed AG Health Report Cross-site replication health between two linked Always On availability groups. View report →

Service Broker

Get-sqmServiceBrokerHealth Service Broker Health Endpoint, per-database status, queues, and undeliverable messages. View report →

Backup & Restore

Invoke-sqmRestoreTest Restore Test Evidence Auditable restore test: data volume, duration and throughput for a recurring restore-test obligation. View report → Get-sqmDatabaseRestoreHistoryIllustrative Database Restore History Last restore date per database, explicitly listing databases that were never restored rather than omitting them. View report →

Security

Get-sqmSysadminAccounts Sysadmin Accounts Report Every sysadmin-role login, flagged as SA, BUILTIN\Administrators, excluded, or unexpected. View report → Invoke-sqmLoginAudit Login Audit Report Policy violations, password age, and inactive logins across the instance. View report → Get-sqmLoginSettings Login Settings Every login with its default database and default language setting. View report → Get-sqmADGroupMembersIllustrative AD Group Members Direct members of an Active Directory group, by SamAccountName and type. View report → Get-sqmADGroupMembersRecursiveIllustrative AD Group Members (Recursive) Group members resolved through nested groups, with recursion depth per member. View report → Get-sqmADMemberGroupsIllustrative AD Member Groups Every AD group - direct and nested - that a user, group, or computer belongs to. View report → Get-sqmLoginPermissionsIllustrative Login Permissions Server and database roles plus explicit GRANT/DENY permissions, per login. View report → Get-sqmLoginLastAccessIllustrative Login Last Access Last known access per login, combining live sessions and error-log entries since SQL Server keeps no true last-login timestamp. View report →

Diagnostics & Health

Get-sqmDatabaseHealth Database Health Report Backup status, VLF count, CHECKDB age and autogrowth events across every database on an instance. View report → Get-sqmAgentJobScheduleReport Agent Job Schedule Report Every SQL Agent job with its schedule, last run status, and average duration. View report → Get-sqmConnectionStats Connection Statistics Active connections grouped by application, host and login. View report → Get-sqmDiskSpaceReport Disk Space Report Free space per volume with a time-to-exhaustion estimate from collected history. View report → Invoke-sqmSetupReport SQL Server Setup Report Critical issues, security posture, and database overview for a freshly checked instance. View report → Get-sqmTempDbRecommendation TempDB Recommendation TempDB file count and configuration checked against best practices. View report → Get-sqmSpnReportIllustrative SPN Report Registered vs. expected Kerberos SPNs for a SQL Server instance, with ready-to-run setspn commands. View report → New-sqmSetupReportIllustrative Setup Event Replay Self-contained animated HTML replay built from a setup event JSON-Lines timeline. View report → Get-sqmDatabaseSpaceReportIllustrative Database Space Report Data and log file fill-level per database, flagged against warning/critical percent-used thresholds. View report → Get-sqmFileGrowthHistoryIllustrative File Growth Report Forecasted days-until-full per database file from a linear regression over recorded size history. View report → Get-sqmAutoGrowthReportIllustrative AutoGrowth Report Percent-based growth, too-small/too-large MB growth, and unbounded log files flagged against best practice. View report →

Performance

Get-sqmBlockingReport Blocking Report Live blocking chains with head blocker, wait time, and the exact statements involved. View report → Get-sqmMissingIndexes Missing Indexes Report Impact-scored index recommendations from the DMV cache, ranked by seeks/scans and cost. View report → Get-sqmIndexFragmentation Index Fragmentation Report Fragmentation percent and page count per index, with a REBUILD/REORGANIZE recommendation. View report → Get-sqmLongRunningQueries Long-Running Queries Currently executing queries beyond a duration threshold, with wait type and CPU time. View report → Get-sqmPerfCounters Performance Counters Top SQL Server performance counters from sys.dm_os_performance_counters. View report → Get-sqmServerUtilization Server Utilization Trend CPU and memory utilization sampled over time, with min/max/average per metric. View report → Get-sqmWaitStatistics Wait Statistics Report Top wait types from sys.dm_os_wait_stats, ranked by accumulated wait time. View report → Invoke-sqmQueryStore Query Store Diagnosis Top-N queries and detected Query Store issues for a database. View report → Invoke-sqmPerfBaseline Performance Baseline Comparison Wait stat and perf counter deltas between two captured baselines. View report → Get-sqmDeadlockReportIllustrative Deadlock Report Deadlock victims, involved statements, and a link to the XDL graph for each event. View report → Invoke-sqmExtendedEventsIllustrative Extended Events Diagnosis Aggregated session events with detected performance issues by category and severity. View report → Get-sqmBlockingHistoryIllustrative Blocking History Past blocking incidents captured from Extended Events, with head blocker, wait time, and both statements. View report →

SQL Configuration

Compare-sqmServerConfigurationIllustrative Server Configuration Comparison Configuration, logins, and migration-relevant objects compared between two instances. View report → Export-sqmDatabaseSettingsIllustrative Database Settings Report Per-database Options snapshot (recovery model, compat level, ANSI/AUTO_* toggles) as JSON with an HTML companion. View report → Export-sqmServerConfigurationIllustrative Server Configuration Report sp_configure, instance properties, services, TempDB, Database Mail, and linked servers as a JSON snapshot. View report →

Inventory & Search

Export-sqmDatabaseDocumentation Database Documentation Structured per-database documentation: properties, backups, files, and users. View report → Invoke-sqmInstanceInventoryIllustrative Instance Inventory Full instance snapshot: properties, databases, logins, linked servers, Agent jobs, and Always On, in one report. View report →

Cluster & Services

Test-sqmSSISPackageCompatibilityIllustrative SSIS Package Compatibility Deprecated components, providers, and protection-level checks for a SQL Server upgrade. View report →

TLS & Certificates

Get-sqmCertificateReport Certificate Report AlwaysOn, TDE, Service Broker and backup encryption certificates with expiry traffic-lights. View report → Get-sqmTlsStatusIllustrative TLS / SSL Status ForceEncryption, bound certificate validity, and SCHANNEL TLS 1.0-1.3 protocol state per instance. View report →

Other

Get-sqmServerHardwareReport Hardware Report CPU, memory, storage and NUMA configuration for capacity planning and sizing checks. View report →