Project Description
Easily compare server configuration. "Grid" layout shows configuration of the full farm in one table. Export to Excel for filter, sort, and pivot chart.

  • Do admin tasks faster
  • Scale up beyond RDP
  • Add new servers without fear
  • Verify consistent configuration

  • New WSP format
  • Central Admin > Monitoring > SPDash easy navigation
  • View server config data in table format
  • Export to Excel
  • Timer job refreshes data cache of XML files
  • Wide screen layout for SharePoint 2013
  • Automatic hive (14/15) detection for SP2010/2013 support

Data Sources
  • WMI query
  • Global Assembly Cache
  • IIS web.config
  • Logical disk size and space
  • File versions (to confirm patching)
  • Display Local Administrator members
  • Kerberos SPN for all managed accounts and farm machines

SharePoint farms have many servers with various services, applications, traffic patterns, and purposes. Having "grid" scripts like the below sample screen-shots can save lots of time. What's a "grid"? Simple. I wanted to build a real-time Excel spreadsheet to display ALL configuration without RDP. RDP won't scale. While great for 1-2 servers, it's awful for 10+ servers. Having confidence in your configs and knowing everything is 100% consistent are BIG steps forward for most admins.


Please drop me a line via email or Twitter @spjeff with ideas. I'm always open to suggestions and improvements.

All the best,

Last edited Apr 30, 2014 at 3:08 AM by spjeff, version 22