Hi everyone , hoping someone could offer some advice on this one.
I have a vast list of SQL servers in a .txt file.
My windows colleagues have granted WMI access for me to a number of machines , but it seems not the entire list.
Can anyone offer any advice \ scripts that I could run against the list that would output into excel that would show successful connections , and those that fail ?
Any advice or help appreciated. Any comments in the scripts would be excellent as they help me to learn what is happening in the script.
you can simply issue any WMI query to the server and see if it fails.
Powered by IDERA