We are migrating the dns entry for our SQL Server database from an machine name to a C-Name, in preparation for moving it from a bare metal box to a virtual machine. We have switched all the connection strings we know about and also issued instructions across our department, asking everyone to switch their connections in case there are one-off apps or db connected spreadsheets, etc.
We would like to monitor the traffic coming into the box to verify that there is no incoming traffic that got to the server via the old machine name. Is there any way to do this? What I need specifically is the url that all of the clients used to reach the server. We tried monitoring the port with Wireshark but that didn't seem to provide the info we needed.