Reporting

To change the Chassis to their common names as described here, use this expression to convert the 36 chassis numbers to their names (like lunch box and pizza box, or more common Desktop, Laptop, and Portable):

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.