View client connection properties from the server.
Currently there's no way to see whether a user arriving at the database is connecting by instance name or port number, or by server name, ip, or alias.
Being able to see this would make it simpler to plan migrations / detect deviations from a standard without causing unwanted disruption.
More info: http://dba.stackexchange.com/questions/151410/find-sessions-connected-by-ip
Upvotes: 2<=-=Mar 13 2017 6:35AM=-=>
Thanks for the suggestion. We’ll be tracking to see how much interest this generates. We could consider the idea of auditing this information if it can easily be ascertained and there is high demand for this requirement.
Is there any update regarding this feature?