select *
from v_collections
where
RefreshType=4
or
RefreshType=6
RefreshTypes=4 : only the option "Use incremental updates for this collection" is enabled.
RefreshTypes=6 : the Options "Use incremental updates for this collection" and "Schedule a full update on this collection" are enabled.
select
CollectionID.
CollectionName,
Flags,
CollectionType,
LimitToCollectionName,
case
when (RefreshType=1) Then 'No Full, No Incremental'
when (RefreshType=2) Then 'Yes Full, No Incremental'
when (RefreshType=4) Then 'No Full, Yes Incremental' when (RefreshType=6) Then 'Yes Full, Yes Incremental'
end as CollectionUpdateOptions
from
v_collections