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…
SCCM Configmgr Technical Preview 1802 available

  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…
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.…
SCCM Configmgr Technical Preview 1801 available

  Microsoft released first ConfigMgr Technical preview version for this year 2018 with some exciting features. To use the technical preview, you must first install a baseline version of the technical preview build i.e Technical Preview 1711. After installing a baseline version, you then use in-console updates to bring your installation up-to-date with the most…
Configmgr 1710 Hotfix Rollup (KB4057517) is available

After the release of Configmgr Current branch version 1710 ,one of the primary issue was that ‘clients are not upgraded on systems that are running Windows Server 2008 SP2’ ,installation terminates with error code ‘Faulting application ccmsetup.exe, version 5.0.8577.1000, time stamp 0x5a03cc4c, faulting module KERNEL32.dll!K32EnumProcessModules’ So Microsoft released hotfix rollup update for Configmgr 1710 that…
SCCM Report for Missing Boundaries and Troubleshooting

Note:If you are running Microsoft Endpoint Manager Configuration Manager 2002 and later, this post is not applicable. In 2002 and later builds, the boundary group information is available as default value for client devices and you dont need to extend the custom MOF file. For more information about boundary groups in build 2002 and later,…