Hi,
I am not a SQL guru and I have not found a canned report that does this, but I am looking for a report that lists the Primary and Secondary DNS servers per node, or per server in Windows environment.
We are changing out DC's and I need to know what server is primary and which is secondary on a bunch of my servers. We had an issue replacing our primary server and need to make sure when we do our secondary that we do not have the same issues.
Also looking for a report listing all users listed in local Administrators group per node.
Any help with either of these reports will be greatly appreciated.
Thanks
Aaron