List all content DBs or - Overview of your MOSS / WSS farm

Written by KbNk

Friday, 08 January 2010 13:04

I was wondered how to get an overview of all databases related to MOSS or WSS. Because I have some other applications running or had to test some functionalities in the past and forgot the names of DBs,
now when it is time to delete not required DBs and free up some space I was looking for some commang/tool how to list really all DBs that should not be touched and are still functional and required.
I found the tool called SPSFarmReport, you just double click it and it will list you nice report about yout farm including names and usage of content databases.
you will find answers to all following questions:

- How many servers exist in the farm?
- What services are run by each server in your farm? Which server is the Query/Indexer?
- Which server(s) host(s) the Central Administration web site in the farm?
- How many SSPs exist in the farm?
- Which is the default SSP in the farm?
- What is the URL of the administration site of an SSP?
- What is the URL of the My Site provider of an SSP?
- What Web applications are associated with each SSP?
- Which application pool is associated with each web application in the farm?
- Which account is used to run a specific application pool?
- How many content databases are associated with each web application and how many site collections does each have?
- What AAMs are configured for each web application?

Here is link with more information and download link:

http://spsfarmreport.codeplex.com/

Cheers KbNk;