I'm going to show you how to use SQL Server Management Studio to get data from Configuration Manager. I want to thank Adam Cook and Adam Gross who both gave me the encouragement to finally put this together.
For best SQL readability, make sure you're watching in HD.