SPSFarmReport

The SPSFarmReport was designed to be a tool that can be used to gather farm related information on environments where Windows SharePoint Services 3.0 or Office SharePoint Server 2007 is installed.

The very purpose of this tool is to help folks in Support understand the topologies deployed in SharePoint environments they troubleshoot. This is not an error reporting tool and does not make any change in the environment. The tool makes use of the SharePoint Object Model to query farm-related information.

Some very basic information about the Farm topology is gathered. We have some common questions asked when working through a support incident. These questions include: - 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?

SPFarm gathers the relevant information to answer most of the questions listed above. I find it very useful when you’re troubleshooting a medium/large server farm environment not knowing which services are run where.