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"…
Author: Eswar Koneti
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…
Client Center tool is designed for IT Professionals to troubleshoot SCCM/CM12 Client related Issues. The Client Center for Configuration Manager provides a quick and easy overview of client settings, including running services and Agent settings in a good easy to use, user interface. Here you go with Client center Beta Version : http://sccmclictr.codeplex.com/ when you try to install this app, It always connects to Internet to install the app else will Fail. How to use this application without connecting to Internet ? On the Computer where you installed the click once application,files resides on the below path. Go to…
In this post,I will get some information about Distribution Points and content locations when you Distribute Packages and what happens and Tips . 1.How to set Drive Settings when installing Sec site DP role ? 2.How to avoid selecting the most disk space drive as Content location(DP) ? 3.How to check what are the next available Drives for Content location ? 4.How to remove DP role,Verify it is removed and reinstall the Role ? when you install SCCM 2012 Secondary Site from primary ,Management point and Distribution Point roles will be added by Default and you choose the settings in…
Justin Gao Documented how to deploy Win 8 Using SCCM 2012 SP1 Beta as System Center 2012 Configuration Manager SP1 beta Supports now. In this post , Justin documented how to use System Center 2012 Configuration Manager(SCCM 2012) SP1 Beta to deployment Windows 8 . Including these parts: Configuring a Distribution Point to Support PXE Capturing a Reference Computer Preparing the Site to Support Operating System Deployment Deploying an Operating System Image to a Bare Metal Client Installing the Operating System Image on a Bare Metal System Complete post and download PDF document step by step,available here P.S:Please use…