spprobe2010.exe - SharePoint 2010 Farm probe tool
spprobe2010 [-help] [-farm] [-granular] [-webapp ["url"] ] [-sql] [-services] [-listitems] [-help] [-user ["userAccount"] ] [-servapp] [-farmadmins].
-help : Provides help on the tool usage.
-farm : Gets information about the compete SharePoint farm.
-granular : Gets detailed information about the compete SharePoint farm.
-webapp : Provides information about the webapp specified as the next argument.
-sql : Opens up an SQL interface to write queries to interact with SQL backend.
-services : Provides the list of services running on each server in the farm.
-listitems : Gets detailed information all items in the list, including permissions.
-user : Validates if the passed user is a Farm Administrator.
-servapp : Gets detailed information of Shared Service Applications along with Service Application Database access and status.
-farmadmins : Get the list of all the farm administrators in the sharePoint farm.
This is a very handy tool to find out detailed SharePoint Configuration and troubleshoot the issue related to configuration and backup. This tool would tell us what services are running on what servers in the SharePoint Farm and which of the servers is running the central administrator service. As we know the server running the Central Administrator Service should be the client in the backup policy for SharePoint Agent for NetBackup.
Apart for giving the detailed permissions on lists and list items, it find out if the SQL is Clustered, Does SharePoint setup is pushing data to the BLOB store.
This gives out details on Web Applications, Site Collections, Subsites, Farm Administrators, Shared Service Applications, SharePoint Help Search Service and Shared Services Applicaitons and Application Proxies (SP2010 2010)
Imagine the effort it takes to manually check all this information on the SharePoint farm and note it down. This has all been automated in this tool.
Service Application details
1 : Service Application Type : Microsoft.Office.Access.Server.MossHost.AccessServerWebServiceApplication
Service Application Name : Access Services Status : Online
2 : Service Application Type : Microsoft.Office.SecureStoreService.Server.SecureStoreServiceApplication
Service Application Name : Secure Store Service Status : Online
Database : Secure_Store_Service_DB_aeb4ab9522e9499fb0e98c8ca9b5a33f Status : Online
Account XXXXXXXXX\administrator has access : TRUE
8 : Service Application Type : Microsoft.Office.Excel.Server.MossHost.ExcelServerWebServiceApplication
Service Application Name : Excel Services Application Status : Online