For the following example I’ve chosen to limit my results to all values in V_Collection for the “All Systems” collection with a query that looks like this: select * from V_collection where Name = ‘All Systems’ Which returns: Take note of the columns in the red boxes as we are going to use them in a moment.Now you may be wondering what exactly does “Refresh Type” mean and why does he have it in a box.
When setting up a software update solution, it's really important that you start with first things first—and the first thing is planning.
An important part of the planning process for SCCM 2012 is developing criteria that you can use to determine when you have reached an acceptable compliance level for updates.
Here is an example: In the scenario above, let’s say that a new SCCM client is added to SCCM at pm on Monday.
It will fall into the “All Systems” collection within 30 minutes, so about pm.
In that case, we have to put on our thinking caps and go straight to the source, SQL.
Since we know the information we want has to do with collections why don’t we start with a quick overview of the data available in V_Collection.
This post is a complete step-by-step SCCM 1606 upgrade guide.
If you’re looking for a complete SCCM 1511 installation guide, see our blog series which covers it all.
The cycle does not always run immediately, and may run as a background thread at a low priority.