SCCM 2007 SP2 Upgrade – Prereq Checker

Posted on Updated on

I’m working on upgrading our sites to the recently released SP2 for SCCM 2007 so as to support Windows 7 and Server 2008 R2.  In using the prerequisite checker, I was a given an upgrade warning that “All distribution points in the site to be upgraded should have the latest version of software distribution packages before beginning the upgrade process”.  In looking more closesly at the warning (within log file C:\ConfigMgrPrereq.log) there was information on the query being executed to determine if any packages have potentially mismatching versions.

Using my Google-fu, I found a post from the ConfigMgr Support Team Blog which led me to a query to determine the impacted packages that I was able to run within SQL Server Management Studio (query below).  Unfortunately, almost all of our packages are impacted, so I am just going to disregard the warning for now….

select Name, PkgID, SourceVersion, StoredPkgVersion
from SMSPackages
where StoredPkgVersion <> SourceVersion


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s