SCCM Configmgr Current Branch 1806 is now available

Microsoft just released SCCM Configmgr Current Branch 1806 as in-console update for first wave customers (opt-in) which means ,you can run PowerShell script to get this update in your console . This build can be applied to your Configmgr sites running on 1706 ,17010 and 1802 .This build version is not available as standalone media…
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…
Configmgr troubleshooting clients with update scan issues for office 365 client updates

Introduction: Office 365 ProPlus is one of the subscription service plans in the new Office. It is productivity software (including Word, PowerPoint, Excel, Outlook, OneNote, Publisher, Access, Skype for Business) that is installed on your desktop or laptop computer. Office 365 ProPlus is a user-based service that allows people to access Office experiences on up…
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…
How to Deploy Microsoft Yammer Client using SCCM Configmgr

Yammer  is enterprise social networking service used for private communication within organizations. Access to a Yammer network is determined by a user's Internet domain so that only individuals with approved email addresses may join their respective networks. Yammer can be used to discuss ideas, share updates, and crowd source answers from co-workers around the globe.…