I'm working on implementing encrypted connections within my team to protect against packet sniffing, however a few developers seem behind on implementing encrypted connections. The below query helped me identify those developers for follow-up, and gave me the information they needed to identify which application was making the unencrypted connections.
select sessions.login_name
, sessions.program_name
, sessions.host_name
, sessions.login_time
, sessions.last_request_start_time
, sessions.status
, sessions.cpu_time
from sys.dm_exec_connections as connections
inner join sys.dm_exec_sessions as sessions
on connections.session_id = sessions.session_id
where connections.encrypt_option = 'FALSE'
order by sessions.login_name
No comments:
Post a Comment