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.
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.
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.