Troubleshooting Slow Collection Evaluation in SCCM Boundaries and Boundary Groups in SCCM As per Microsoft, a boundary is a network location on the intranet that can contain one … The yellow and red charts are hyper-linked to the tables shown in the bottom section. The Collection Refresh Types is also hyper-linked to table in the BOTTOM section. sccm sql query Current Excel SQL query Script: I have created SQL query which is connect to SCCM server and get the below details. Once you are in that Azure Group Sync tab, you would be able to see your tenant detail and there is a search box over there. Create a report with gathered data an any … To create the membership rule, find the collection under the Assets and Compliance node of the SCCM console, right click it and select Properties. Collection Membership count, biggest to smallest. The collection membership rules for FEP are complex and since the FEP dashboard relies on this information, the collections are locked and the membership rules cannot be … If you want to see the SQL you would query the table Collection_Rules_SQL. Posted on. Most likely be SMS_G_System_ADD_REMOVE_PROGRAMS.Version. You can then run this query by right-clicking on it and selecting the run option. SCCM Query based membership rule for collection failing SCCM 2012 / 2016 SCCM Collection Query based on multiple Now that you've got your custom WQL query, you can use it to define a new collection membership rule. 5. Create a Collection for Workstations Open Configuration Manager console. SCCM SQL query I thought it might be useful to share out a …