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'…
Author: Eswar Koneti
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…
Sometimes I find Difficult to locate specific site from the Hierarchy(mostly if you are in large environment with many nodes) until you know where they attached to. I use the report data most of the times as reference to locate where the site resides based in its reporting site (primary) and primary site reporting to which. Select C.servername,b.SiteCode,C.SiteName,C.ReportingSiteCode, C.InstallDir, Case b.Status When 0 Then 'OK' When 1 Then 'Warning' When 2 Then 'Critical' Else ' ' End AS 'Site Status', Case C.Status When 1 Then 'Active' When 2 Then 'Pending' When 3 Then 'Failed' When 4 Then 'Deleted' When 5…
If you are Performing package cleanup,this query might help you to Identify how many packages with no advertisements(standard advertisement and Task Sequence) so you know What action to Take next! select v_Package.PackageID, v_Package.Name,v_Package.SourceVersion,v_Package.SourceDate from dbo.v_package Where packageID not in (select PackageID from dbo.v_Advertisement)and PackageID not in (SELECT ReferencePackageID FROM v_TaskSequenceReferencesInfo) and v_Package.name not like '%osd%' and V_package.PackageType ='0' group by v_Package.PackageID, v_Package.Name,v_Package.SourceVersion,v_Package.SourceDate order by v_Package.PackageID If you want to know other packages like OSD,Driver,Software update packages,you can replace Package type with below Values : When 3 Then ‘Driver Package’ When 4 Then ‘Task Sequence Package’ When 5 Then ‘software Update…