PowerShell: Check TDE Status Across Fleet

Audit TDE (Transparent Data Encryption) status across your SQL Server fleet with our free PowerShell script. ELSIE SQL GUARDIAN compatible—use it standalone or integrate with your 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.