Reporting – Page 2 – All about Microsoft Endpoint Manager

How to install Data warehouse service point in SCCM Configmgr and get the historical data

Posted on October 27, 2018 by Eswar Koneti | 10 Comments | 4,053 Views

Introduction: Customer is running on SCCM Configmgr current branch 1806 and configured with site maintenance tasks to delete the aged data for X number days . when you configure the site maintenance task ,the data which is older than X number days get deleted from site database which is expected. So customer has asked…

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 | 5,111 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…

SCCM Configmgr Technical Preview 1802 available

Posted on February 14, 2018 by Eswar Koneti | 1 Comment | 1,806 Views

On this Valentine day (Feb 14,2018 ), Microsoft released Feb 2018 Technical preview version 1802 for Configuration Manager with large number of features (21) that ever released before. These monthly Tech previews generally will be released on Friday's but this time ,shipped few days earlier. You can install this version to update and add…

Download SCCM Configmgr CB 1606 SQL views documentation

Posted on July 25, 2016 by Eswar Koneti | 2 Comments | 1,186 Views

Microsoft released new version of SCCM Configmgr Current Branch 1606 (YY MM) with lot of new features and improvements to the existing features. You can install this update via in-console update. With this new update ,there are also couple of newly added SQL views compared to its previous update (1602) which will help us to…