What’s new in SCCM ConfigMgr 1902 Reporting

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…
Configmgr SSRS failed to upload RDL with error code :definition of this report is not valid or supported by this version of reporting services

  when you try to upload RDL (report definition language) file into your SSRS reports ,you will hit with the following error “The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with a later version of Reporting Services, or contain content…
SCCM Configmgr CB 1802 SQL Views documentation

  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

  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

  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…