I am starting new at an organisation as a Junior DBA and wanted to know more details about all database servers in this organisation. I was wondering if there could be a way to show a list of all existing database servers on the network. I have never done this before but wanted to know the best way to proceed. I also came across MS MAP toolkit but was wondering what might be the network risks, pros and cons of using that tool. Any suggestions and answers are welcome.
The MS Map tool works great. I would let your network security team know that you need to run the tool as it does scan the entire network. I have never had it cause any network slowness issues or anything like that.
A starting point would be to run `OSQL -L`. Or `SQLCMD -L`. Take the output of that, and connect to each server identified and run the same command. See if you can find any other servers. I once wrote an SSIS package to do just that and found quite a few servers that the in-house DBA didn't know about.