SQLTeam.com | Weblogs | Forums

Database list by Servers

Hello,
We have 100+ servers/Instances and each servers Instance contains few databases and i would like to get the all database list by each server/instance.
Instead of running query on each sever to get the database list, can i get database list by servers?
Ex.
Server1
DB1
DB2
DB3
Server2 DB1
DB2
DB3
DB4

Thanks for your help!

Something like this is your best approach.

https://gallery.technet.microsoft.com/scriptcenter/Create-Inventory-of-SQL-19d61963

Powershell to crawl your network but it would require some setup.

Thanks.
I will check it out, appreciate it!