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….
where StoredPkgVersion <> SourceVersion