PowerShell: Check TDE Status Across Fleet

Audit TDE (Transparent Data Encryption) status across your SQL Server fleet with our free PowerShell script. Use it standalone or integrate with your DBAOps Sovereign compliance pipeline.

Usage

.\Check-TDE-Status.ps1 -ServerInstance "PROD-SQL-01"

The script queries sys.dm_database_encryption_keys and reports encryption state per database: No encryption, Encrypted, Encryption in progress, etc.

Free for RHOYLLE users. See Scripts & Add-ons for TempDB ARD, Domain Discovery, and more.