SQL

“The site database has a backlog of SQL change tracking data”

One of the more common prerequisite warnings I see when updating SCCM in my lab is:- [Completed with warning]:The site database has a backlog of SQL change tracking data. For more information, see https://go.microsoft.com/fwlink/?linkid=2027576 SCCM Update Pack Installation Status We can see the same warning in ConfigMgrPreReq.log What does this warning mean? Starting in SCCM …

“The site database has a backlog of SQL change tracking data” Read More »

SCCM Report to group number of outstanding updates, for a collection, in 30 day intervals

I wasn’t getting what i needed from the built in SCCM SSRS Reports. Admins were asking for it to be made easier to understand how bad the number of outstanding updates were for the systems they have ownership of. For example, how many of the outstanding updates are 0-30 days old or 60+ days old. …

SCCM Report to group number of outstanding updates, for a collection, in 30 day intervals Read More »