I am a server/SQL admin in a large organization. We have thousands of SQL databases on many clusters and individual servers supporting many departments. Each major department has their own DBA's who (we hope) document their database structures.
The issue we have is not the actual database documentation, but rather the high level "what is out there", "who owns it", "what application connects to it", etc. We do have some documentation that has been compiled over the years, but nothing comprehensive and complete. Us admins have been asking management to get involved in this for years now (apps, servers, SQL, etc.) and nothing went forward so I have taken it as my personal task in what little free time I can scrape up.
Before I spend too much time building requirements I wanted to see if there are any tools, templates, scripts, etc. that have been created for this purpose. Commercial or non-commercial is OK. Something that goes beyond just SQL to document servers, applications, etc. would be a huge benefit. Tools that would scan the servers for info would be great because none of us really has time to manually discover and document the basic data. I have been hunting for something like this without much luck.
Can anyone make some suggestions?