Jump to content

Find list of all collections with incremental check selected

Guest Ajit

Recommended Posts

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? 

Link to comment
Share on other sites

  • 4 months later...

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


Link to comment
Share on other sites

Join the conversation

You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...