The SQL Query here will allow you to retrieve information from your SQL Server installation pertaining to your TCP Endpoints.
SQL Query:
Select
Name 'Endpoint Name',
'Protocol' = Case
When Protocol = 1 Then 'HTTP'
When Protocol = 2 Then 'TCP'
When Protocol = 3 Then 'Name Pipes'
When Protocol = 4 Then 'Shared memory'
When Protocol = 5 Then 'Virtual Interface Adapter'
End,
Port,
'Type' = Case
When Type = 1 Then 'SOAP'
When Type = 2 Then 'TSQL'
When Type = 3 Then 'Service Broker'
When Type = 4 Then 'Database Mirroring'
'State' = Case
When State = 1 Then 'Stopped'
When State = 2 Then 'Disabled'
Else 'Started'
'Administrative Endpoint' = Case
When Is_Admin_Endpoint = 0 Then 'No'
When Is_Admin_Endpoint = 1 Then 'Yes'
IP_Address
From Sys.TCP_Endpoints
No Comments