sccm software update not able to select options for win 7

[guest]

we currently encounter that there are no option to select for windows 7 under the windows category for software update in SCCM only available option for windows 7 will be the language pack and we are currently running wsus sp2 and SCCM version is 4.00.6487.2000, pls advise. thank you.

[guest]

Well, in the previous query, since we use wildcard %, so the returned instance actually refers to “Windows 7 Language Packs’, not “Windows 7” (as we can see the returned CategoryInstanceID is 198, if we look at CI_LocalizedCategoryInstance.csv file for the same value, it refers to Windows 7 Language Packs).



For now, please execute the following query in the site DB:



Delete from CI_LocalizedCategoryInstances where CategoryInstanceID=150

Delete from CI_CategoryInstances where CategoryInstanceID=150



Or you can delete from the two table for the rows with CategoryInstanceID as 150 and delete the two rows directly from there. Then force a sync again to see if Windows 7 is now populated under the product list from SCCM console.


--------------------------------------------------------------------------------

[guest]

had checked on the WSUS console and the options for windows 7 is there but unchecked, but we recheck in SCCM SUP, the option is not there for us to select on windows 7, please advise. Thank you.

[guest]

so the question is that the product list in WSUS console is different from what show in SCCM console. This is similar to a problem I worked with Mark previously in this thread:

http://social.microsoft.com/Forums/en-U ... cdfa9380d4



You can have a check against the above thread, in that case, Mark is unable to see FEP from SCCM console but can see FEP from WSUS console. Hence we can use the same way to fix our problem. In short, we need look inside the following two tables



CI_LocalizedCategoryInstance

CI_CategoryInstances



You can derive the CategoryInstanceID from CI_CategoryInstances for “Windows 7” and then look for the same id in CI_LocalizedCategoryInstance table. Remove the references for “Windows 7” and force a sync to WSUS from SCCM console again.

[guest]

Well, in short, the product list for SUP list is synced from WSUS server. During the sync, if SCCM found any missing product, SCCM will pull the synced product list in the local DB (e.g. CI_LocalizedCategoryInstance, CI_CategoryInstances). However, what we have see from SCCM console is queried from v_CategoryInstances. So in our case, the problem happens that Windows 7 present in CI_LocalizedCategoryInstance table but doesn’t exist in v_CategoryInstances. That’s why we can’t see the node from SCCM console and it doesn’t sync that from WSUS.


To confirm, we can query from view v_CategoryInstances and Windows 7 shouldn’t list here in our case.

Select * FROM v_CategoryInstances WHERE CategoryInstanceID

IN (SELECT CategoryInstanceID FROM fn_ListUpdateCategoryInstances(1033) WHERE CategoryInstanceName like '%Windows 7%')



So what we need to do is to remove the entries from CI_LocalizedCategoryInstance for “Windows 7” and force the sync again.



Note that as this operation is performed against DB directly, it is suggested to back up your DB firstly.

--------------------------------------------------------------------------------

[guest]

Well, in the previous query, since we use wildcard %, so the returned instance actually refers to “Windows 7 Language Packs’, not “Windows 7” (as we can see the returned CategoryInstanceID is 198, if we look at CI_LocalizedCategoryInstance.csv file for the same value, it refers to Windows 7 Language Packs).



For now, please execute the following query in the site DB:



Delete from CI_LocalizedCategoryInstances where CategoryInstanceID=150

Delete from CI_CategoryInstances where CategoryInstanceID=150



Or you can delete from the two table for the rows with CategoryInstanceID as 150 and delete the two rows directly from there. Then force a sync again to see if Windows 7 is now populated under the product list from SCCM console.


--------------------------------------------------------------------------------