eyespi20 (6/24/2014)

---

Here are three links to PowerShell scripts that do this work in various methods. A Google search of "powershell sql server inventory" brings up quite a few links. Do like I did and take some from here and some from there to create your own that serves your exact needs. It's not hard to do, but may take a bit of time -- not nearly as much time as doing the inventory by hand though.

http://blogs.technet.com/b/heyscriptingguy/archive/2013/05/07/use-powershell-to-discover-diagnose-and-document-sql-server.aspx

http://gallery.technet.microsoft.com/scriptcenter/PowerShell-SQL-Inventory-e9b92dac

http://colleenmorrow.com/2012/05/29/building-a-sql-server-inventory-part-1/