I work for a shop with 300+ physcial servers and about the same number of VM guests. We use Puppet heavily and are mostly Centos5.5 and about 20% Centos6.2.
We use Google docs for storing various things. We have a rack spreadsheet which has locations, names and switchports. We have an IP spreadsheet with all the subnets and static hosts.
The Google spreadsheets are basic but they work and they don't enforce a heavy process mindset. We've looked at a number of CMDB systems but they are heavy and seem to want to solve a bunch of large enterprise issues that we don't have.
- How do I create a Google spreadsheet that has all of my hosts (hostname, location, MAC, IP, etc) as lines on a page and also create various views to the data.
FWIW, I just spent a couple hours reading about Google gadgets and it's clear I could build this but it seems like this is such a common problem that there must be something I can cargo-cult into a solution.