SQL reporting – All about Microsoft Endpoint Manager

What’s new in SCCM ConfigMgr 1902 Reporting

Posted on March 28, 2019 by Eswar Koneti | 0 Comments | 3,529 Views

Microsoft has released SCCM ConfigMgr Current Branch build version 1902 and is available as in-console update and baseline version. You can apply this update on sites that runs on 1710,1802,1806 and 1810. If you want to install new site ,you can download 1902 as baseline . Download baseline version of 1902 from volume licensing or…

SQL query to get client count with status active obsolete missing for collections in tabular column

Posted on March 19, 2018 by Eswar Koneti | 3 Comments | 4,586 Views

Quick blog post on how to get client count with active obsolete and missing status for collections in a nice tabular column. I used 3 SQL views in this query V_r_system ,v_FullCollectionMembership_valid and v_Collection with sum and case statements. You can use this SQL code in report creation with collection prompt and also create…