I noticed that all our test systems are installing The Software "Software Update Plug-in" and then installs the "Software Update Plug-in Upgrade". This is redundant and upon inspection it appears to be a version check issue within the "All Windows Computers Requiring Software Update Plug-in Upgrade" filter.
The Filter's SQL is:
dbo.fnVersionToComparableVersion(i.[Product Version]) BETWEEN dbo.fnVersionToComparableVersion('6.2') AND dbo.fnVersionToComparableVersion('7.0.4071.0')
And it should be:
dbo.fnVersionToComparableVersion(i.[Product Version]) >= dbo.fnVersionToComparableVersion('6.2') and dbo.fnVersionToComparableVersion(i.[Product Version]) < dbo.fnVersionToComparableVersion('7.0.4071.0')
Grammatically speaking, the original syntax is mostly correct but Microsoft is using the "Pick a number between 1-10" mentality they learned in preschool and they can't let go. When I think 1-10 I think 1.00001 to 9.99999 and never 1 or 10 as 1 and 10 are boundary values and not implicitly included.
Updated: opps my sql was not quite right.. Fixed