SCCM Reports – Page 3 – All about Microsoft Endpoint Manager

SCCM Configmgr collection SQL identify duplicate computer records with different GUID

Posted on May 31, 2019 by Eswar Koneti | 1 Comment | 30,290 Views

I was working on SCCM report for client health dashboard. During this report creation ,found that ,device appear twice with different GUID ID and resource ID but with same hostname. So i started looking at this issue to see how identify the records with duplicate hostnames. SCCM clients are uniquely identified by a GUID. A…

SCCM Report Get list of devices with pending reboot in a collection with different states

Posted on January 21, 2019 by Eswar Koneti | 10 Comments | 43,958 Views

Beginning with the release of SCCM ConfigMgr Build 1710 or later , you can use the SCCM Console to identify client devices that require a restart, and then use a client notification action to restart them. If you want get this feature enabled on the client side ,you must also upgrade clients to version…

SCCM ConfigMgr Compliance status of client for multiple software update groups

Posted on January 9, 2019 by Eswar Koneti | 2 Comments | 11,784 Views

After long-time ,i am back with quick SCCM Configmgr software update compliance report .A friend of mine asked me today morning that ,he wants to check the compliance report for specific computer (could be VIP ) against one or multiple software update groups that they have created/deployed. How do you check the compliance status…

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,345 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…

Configmgr SSRS failed to upload RDL with error code definition of this report is not valid or supported by this version of reporting services

Posted on June 16, 2018 by Eswar Koneti | 13 Comments | 17,890 Views

Introduction: When working with SQL Server Reporting Services (SSRS), you may encounter an error message stating, "The definition of this report is not valid or supported by this version of Reporting Services." This error can occur when attempting to upload an RDL (Report Definition Language) file into your SSRS reports. In this article, we will…

SCCM Configmgr CB 1802 SQL Views documentation

Posted on March 23, 2018 by Eswar Koneti | 2 Comments | 4,576 Views

With the release of SCCM Configmgr current branch 1802 ,there are some exciting features added from its previous version 1710. When there are new features released ,certainly there will be changes to the database hence sql views/tables created which will help us to create some nice SSRS reports for reporting. So with this current…

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,387 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…

Using SCCM how to check if the user mailbox is migrated to exchange online (cloud) from on-prem exchange

Posted on March 16, 2018 by Eswar Koneti | 10 Comments | 3,161 Views

Introduction: we are in process of migrating users (mailbox) from on-prem to office 365 (Cloud).As part of this project ,one of the requirement is to deploy office 365 proplus (C2R) application to all users replacing old version of Microsoft Office. We use Powershell Application deployment kit which simplifies the complex scripting challenges of deploying…