Automated SQL Inventory Pt. 1 – Instance Information

This will be the first part of a long series defining my custom SQL Server inventory system.  I started my inventory as an exercise to learn my new environment after starting a new job, but it has grown to be very useful for reporting, using as a source for PowerShell to target all my instances, and for basic monitoring.  There are many components to it, so I figured breaking them down piece by piece would be easier to digest.  In this part, I will go through the script I use to pull information about the instance.

Continue reading