Do you want to get the protocols and end point names list of our DB using a single Query? (SQL Server)

Easy to do:

select *  from sys.endpoints

The result of this query will give us the list of SQL endpoints for our SQL Server