Last time it went offline via the fast channel Last time it came online via the fast channel If the device is currently connected to a MP via the fast channel Last Date that a client push was performedĪs reported in Active Directory (Microsoft Windows NT Server 6.3)Īnything EP_ are endpoint protection related fields Last management point that it connected to for policy, etc. Type of certificate used for client communications. Important internal CM internal ID for joining to other tables to get additional data. These ones I have found to be the most useful. Most of these correspond to columns in the Devices node in the console. In this view, there are currently 122 columns. This week in the MMS Tips and Tricks, I decided to show this view, along with using SSMS to filter views. So, this view gives you that without having to do any of those wonderful SQL JOINs we always have so much fun with. Too many times someone wants a report that just lists exactly what they see in the Devices node. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |