In previous post,we saw how to get list of referenced task sequence packages used in Task Sequence which are incomplete. In this report,we see how to get list of Distribution Points who do not have these referenced packages used in Task Sequence so you know all these sites which do not have package may fail during the OSD Policy check. Count : Distribution Points who do not have these packages used in Task Sequence select sitecode,COUNT(distinct packageID) as [Not Distributed] from v_PackageStatusDetailSumm PSD where PSD.Targeted='0' and PSd.PackageID in (select ReferencePackageID from v_TaskSequenceReferencesInfo where PackageID =@TS1) group by psd.SiteCode order by…
Author: Eswar Koneti
If you have any issues with distribution of any packages to child sites or if you are in multi-tier hierarchy,You get face issues with packages not replicating to child sites due to several reasons and they will be retrying n (specific) number of times until they get right version of PCK file. Preload is Our Friend to fix Package replication issues in better way. To know more about Preload Tool and its usage http://blogs.technet.com/b/configurationmgr/archive/2009/05/07/configmgr-2007-the-preload-package-tool-preloadpkgonsite-exe-explained.aspx How do you copy the PCK files ? Via Network Share ? sending them Via disk if you have large number of packages (this may happen…
Another Interesting report which will help you to identify if there are any packages used in Task Sequence are not available on Distribution Points. If the Reference packages used in Task Sequence not available on DP,your Task sequence will fail and then u come back to fix the issues so lets be proactive . SCCM 2012 presents nice view with compliance level for the reference packages used in Task Sequence. select pkg.Name as [Package Name], Case pkg.PackageType When 0 Then 'Software Distribution Package' When 3 Then 'Driver Package' When 4 Then 'Task Sequence Package' When 5 Then 'software Update Package'…
Wanted to share you results after certification on 70-243 :System center 2012 Configuration manager. If you are enough confident on CM07,you feel this exam is Easy. Below are some of the references that might help you to get certified on 70-243: Skills Measured & Syllabus :http://www.microsoft.com/learning/en/us/exam.aspx?id=70-243#tab2 Do you want to pass Exam 70-243? Here are some good tips.: http://blogs.technet.com/b/smartinez/archive/2012/02/21/do-you-want-to-pass-exam-70-243-here-are-some-good-tips.aspx Free Study Guide : http://blogs.technet.com/b/keithmayer/archive/2012/06/09/get-certified-on-system-center-2012-configuration-manager-exam-70-243-with-this-free-study-guide.aspx#.UI3encXA_YY TechNet Virtual Labs http://technet.microsoft.com/en-us/virtuallabs/bb467605.aspx Survival Guide http://social.technet.microsoft.com/wiki/contents/articles/7075.system-center-2012-configuration-manager-survival-guide-en-us.aspx And your hands on Experience(Lab or production) environment J Good Luck!
Recap about Deployment Re-evaluation Though name indicates what it does but still clearing questions if any. Re-evaluation on Software Updates Client Agent reevaluates(Recheck) software updates for installation status helps when Computers offline/Added newly to collection or removed patches from computers. Scenario: You have created A deployment with List of patches (100) and deployed to collection consists of 100 machines with deadline date 1 week from current date. computers which are online and performs below actions based on the settings you choose before they get the updates like how many are required(missing) ,not required ,installed etc. Software Updates Scan Cycle: Scans…
In my previous report,we saw complete information about Pending packages,installed packages,Targeted but not installed,total packages targeted to DP http://eskonr.com/2012/08/sccm-report-count-of-packages-available-on-distribution-points/ In todays report,we go with count of all packages information at one glance to identify and Fix total number of Packages Distributed out of which how many are installed,Pending Packages. select dbo.v_SystemResourceList.Servername as "Server Name", (select count(*)from v_PackageStatusDistPointsSumm where servernalpath = nalpath) as "Total Packages", (select count(*)from v_PackageStatusDistPointsSumm where installstatus ='Package Installation complete'and servernalpath = nalpath) as "Packages Installed", (select count(*)from v_PackageStatusDistPointsSumm where servernalpath = nalpath and (installstatus = 'Waiting to install package' or installstatus ='Retrying package installation')) as "Packages Pending"…
I was looking at client health percentage other day and found many systems were reported as not healthy though I fixed some of the machines with sccm client installed and able to receive policies. Looked at Database for healthy computers and see double entries with different ResourceID ,client0 and HardwareID0 is NULL. So what next ? I created collection with filter computers with sccm client installed and should be in computers with no sccm client. Collection: select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.Name in (select name from SMS_R_System where SMS_R_System.Client is not null) and SMS_R_System.Client is null Report: select…
The SMSPKG share contains the compressed PCK files for the packages that have been targeted to a particular SMS/SCCM Site. When the SMS /PCK drives Full /Limited space available,you would require to either extend the disk space or the PCK files to different drive But what happens when you move ? Cut and past will work ? are there settings/configurations needs to be done to make the new PCK file work ? P.S :Below are the steps which I have noticed while carrying out this activity and you may have different approach /solution in getting this done. Below is the…