Saturday 16 April 2011

SCCM Prerequisities Check'te Distribution point package version hatasi

Eger SCCM pre. checker'i calistirdiginizda "Distribution point package version;    Warning;    All distribution points in the site to be upgraded should have the latest version of software distribution packages before beginning the upgrade process." hatasi aliyorsaniz asagidaki SQL Query' sini SMS DB sinin bulundugu SQL sunucunuzda calistiriniz. Bold yapmis oldugum yere site code unuzu yazmayi unutmayiniz.

select distinct dps.ID, sitesys.ServerName, ip.IP_Addresses0 from SysResList as sitesys join System_DISC as sys on UPPER(sitesys.ServerName)=UPPER(sys.Netbios_Name0) join ( select dppkg.ID, dppkg.PkgServer from PkgStatus as dppkg join PkgStatus as sitepkg on dppkg.ID = sitepkg.ID where dppkg.Type = 2 and sitepkg.Type = 1 and dppkg.SourceVersion != sitepkg.SourceVersion) as dps on UPPER(dps.PkgServer) = UPPER(sitesys.NALPath) left join System_IP_Address_ARR as ip on sys.ItemKey = ip.ItemKey where sitesys.SiteCode = 'Your3characterSiteCode' and ip.IP_Addresses0 like '%.%.%.%'

Query size hangi paketlerde sorun oldugunu gosterecektir. O paketlerin durumunu System Status\Package Status'den kontrol etmeniz gerekmekte, sorun varsa distribution share ini Paket ayarlarindan kaldirip (remove) bir sure bekledikten sonra tekrar Query i calistiriniz, sonuc bos gelince dist. share'i tekrar listeye ekleyiniz (add).

No comments:

Post a Comment