Configuration Manager's collections can be updated on schedule (Full Update) or incrementally (Incremental Update). It is not good when the latter mechanism reaches more than 200 collections[1]. Of course, viewing the settings of individual collections is not the best idea, it's better to prepare a report querying the data from the SQL database. You can use the v_Collection view for this purpose. In this view there is a RefreshType field, described in the documentation[2],[3].
Expanding the meaning of the RefreshType field, we get, for example, the following query:
SELECT CASE
            WHEN RefreshType = 6 THEN 'Incremental and scheduled'
            WHEN RefreshType = 4 THEN 'Incremental only'
            WHEN RefreshType = 2 THEN 'Scheduled only'
            WHEN RefreshType = 1 THEN 'Manual'
            WHEN RefreshType = 0 THEN 'None'
            ELSE 'Unknown'
       END as Refresh
       , COUNT(*) as Number
 FROM v_Collection
 GROUP BY RefreshType
Â
A sample report using the given SQL query:
Â
Of course, keep in mind that the number of collections using incremental updating is the sum of type 4 and 6, so in our example 13 + 40 = 53 (so we are within the recommendations).
________________________________________________________________________
[1] https://learn.microsoft.com/en-us/mem/configmgr/core/clients/manage/collections/best-practices-for-collections#bkmk_incremental
[2] https://learn.microsoft.com/en-us/mem/configmgr/develop/reference/core/clients/collections/sms_collection-server-wmi-class#refreshtype
[3] https://learn.microsoft.com/en-us/powershell/module/configurationmanager/new-cmdevicecollection?view=sccm-ps
- Support and development of Microsoft and Nintex based applications
- Application design and development including digital processes
- Invoice management
- Requisition management
- Contract management
- Modern Intranet
ISCG sp. z o.o.
Al. Jerozolimskie 178, 02-486 Warsaw
NIP: 5262798378
KRS: 0000220621
Phone