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…
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 Report for Missing Boundaries and Troubleshooting

  Introduction: Boundaries for SCCM define network locations on your intranet that can contain devices that you want to manage. Boundary groups are logical groups of boundaries that you configure. For more information click here Few days ago ,Jason Sandy’s has blogged about boundary group caching and missing boundaries ,more details ,read through https://home.configmgrftw.com/boundary-group-caching-and-missing-boundaries-in-configmgr .…
SCCM Configmgr Report for Boundary group relationships with Fallback Sites

Beginning with Configmgr Version 1702, clients use boundary groups to find a new software update point. You can add individual software update points to different boundary groups to control which servers a client can find. More information about boundary groups and its relation with  software update point changes in 1702 and 1706 ,please refer TechNet…
SCCM Configmgr Get count of software updates with its severity (Critical,Important,Moderate and Low)

Quick post on how to get count of list of updates or count of updates in your Configuration Manager with severity categorised as Critical,Important,Moderate and Low. In order to get this information count of updates with severity, you first need to identify what the SQL views that store this information about software updates. Get the…
SCCM Configmgr Unable to run SSRS reports due to HTTP 500 Internal Server Error

Setting up Configuration Manager current branch (1702) lab for testing. While running the Configmgr reports using IE browser ,http://servername/Reports/Pages/Folder.aspx ,it failed with error code HTTP 500 Internal Server Error. SQL server installed locally on Configmgr box . I have seen this error couple of time but i don't remember what was the solution to get…