How to find out the port of a remote MS SQL server?

Question

Windows Management Instrumentation

The essence of the question, we have n servers and access to them via WMI, how to collect information on the ports on which the instances hang? That is, there is a server on which a couple of instances are spinning; they have ports, how to find out which ports they are and which instance they belong to? The option "come and see" is not very suitable due to the number of servers.

Answer 1

WMI cannot provide a list of network ports used by processes, so it will not work through this method.
From regular means it is possible in this way: raise WS-Management and run a script through PS-Remote that determines the correspondence between "MS SQL process id - ports". The easiest way would be to run this script using ansible, but I suspect that you are not under Linux and WSL is not comme il faut for this.