Find list of all collections with incremental check selected

[Guest Ajit]

We have thousands of collection in sccm and lots of them have incremental setting enabled.  I have to perform cleanup,  how to find list of all collections with incremental setting? 

[Manish Bangia]

Following is the query to be used:

Select * from dbo.Collections where flags like '6'

Note: Meaning of flag is 'Collection Refresh Settings' and it can have following values along with meaning:

1 = Manual Update
2 = Periodic Update
4 = Incremental Updates
6 = Incremental and Periodic Updates