Reporting

One CM SQL View to Rule them All

Profile picture for user PaulW
Posted by PaulW on Sat, 09/12/2020 - 12:03am

A few months ago, I learned of a View in the CM database that is basically every column that you can add in the devices node.  Too many times someone wants a report that just lists exactly what they see in the Devices node.  So, this view gives you that without having to do any of those wonderful SQL JOINs we always have so much fun with.

This week in the MMS Tips and Tricks, I decided to show this view, along with using SSMS to filter views.  So lets take a look at the view.