sys.dm_cryptographic_provider_sessions (Transact-SQL)
Applies to: 
SQL Server
Returns information about open sessions for a cryptographic provider.
Syntax
sys.dm_cryptographic_provider_sessions(session_identifier)
Arguments
session_identifier
An integer indicating the sessions to be returned.
0 = Current connection only
1 = All cryptographic connections
Table Returned
| Column name | Data type | Description |
|---|---|---|
| provider_id | int | Identification number of the cryptographic provider. |
| session_handle | varbytes(8) | Cryptographic session handle. |
| identity | nvarchar(128) | Identity used to authenticate with the cryptographic provider. |
| spid | short | Session ID SPID of the connection. For more information, see @@SPID (Transact-SQL). |
Permissions
Members of the public server role can use sys.dm_cryptographic_provider_sessions to return information about the current connection. To view all cryptographic connections, the CONTROL server permission is required.
See Also
Security Catalog Views (Transact-SQL)
Extensible Key Management (EKM)
CREATE CRYPTOGRAPHIC PROVIDER (Transact-SQL)
Encryption Hierarchy