SCCM Configmgr Remove Collection membership for Direct rule Collections using Powershell

  This blog post is continuation to my previous post ‘Monitor collection evaluation's and remove incremental membership schedule for non-priority collections’ .More information can be found at http://eskonr.com/2019/01/sccm-configmgr-monitoring-collection-evaluations-and-change-update-membership-schedule-using-powershell/ . In this post ,we will see how to improve the collection evaluation performance further by identifying list of collections with direct rule created that have membership…
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…
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 .…