ConnectWise Automate – Finding Hyper-V 2012 servers with Broadcom NetXtreme Adapters

There is a reported issue with Hyper-V servers running Microsoft Server 2012 and Microsoft Server 2012 R2 where BroadCom NetExtreme adapters with VMQ enabled will have VMs lose connectivity intermittently. Information on the issue can be found here: https://support.microsoft.com/en-us/help/2986895/virtual-machines-lose-network-connectivity-when-you-use-broadcom-netxt You can utilize SQLYog to run the query below on a on premise ConnectWise Automate installation.