Month: March 2018

SCCM Configmgr CB 1802 SQL Views documentation

Posted on March 23, 2018 by | 2 Comments | 4,578 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…
Read more »
SCCM Configmgr Current Branch 1802 is now available new features and product enhancements!

Posted on March 23, 2018 by | 1 Comment | 5,496 Views
  Microsoft released Configuration Manager Current Branch build version 1802 an in-console update. You can apply this update on sites that run version 1702, 1706, or 1710. This build also available as baseline version which means, you can use this media to install new ConfigMgr sites. You can download the baseline media either from MVLS…
Read more »
New version of System Center Updates Publisher (SCUP) is available to support windows 10 and server 2016

Posted on March 22, 2018 by | 0 Comments | 3,437 Views
Microsoft released an updated version of System Center Updates Publisher (SCUP) version 6.0.278.0 is now available and can be downloaded here. System Center Updates Publisher (Updates Publisher) is a stand-alone tool that enables independent software vendors or line-of-business application developers to manage custom updates. Using Updates Publisher, you can: Import updates from external catalogs (non-Microsoft…
Read more »
SQL query to get client count with status active obsolete missing for collections in tabular column

Posted on March 19, 2018 by | 3 Comments | 5,388 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…
Read more »
Different methods to setup Azure MFA Registration for O365

Posted on March 19, 2018 by | 9 Comments | 11,770 Views
  Introduction: This is going to be my 2nd or 3rd blog on Azure MFA (Multifactor authentication). Azure MFA is Two-step verification is a method of authentication that requires more than one verification method and adds a critical second layer of security to user sign-ins and transactions. It works by requiring any two or more…
Read more »
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 | 10 Comments | 3,163 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…
Read more »
Conditional Access to prompt MFA if user coming from untrusted location a.k.a exclude MFA from company intranet

Posted on March 13, 2018 by | 2 Comments | 7,663 Views
Introduction: Multi-factor authentication (MFA) is a method of confirming a user's claimed identity in which a user is granted access only after successfully presenting 2 or more pieces of evidence (or factors) to an authentication mechanism. What is  Azure Multi-Factor Authentication ? Two-step verification is a method of authentication that requires more than one verification…
Read more »