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.

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

Features
  • 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

Background
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.



Screenshots

























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

Best,
Jeff

http://www.spjeff.com

Last edited Dec 13, 2013 at 12:09 AM by spjeff, version 21