In my Previous blog,I posted script On How to Refresh/Redistribute One package on List of Distribution Points http://eskonr.com/2013/09/sccm-configmgr-powershell-script-refresh-package-on-multiple-distribution-points/ This post talks about how to Refresh / Redistribute list of packages to Single distribution Point. import-module F:\sccm\AdminConsole\bin\ConfigurationManager.psd1 #Change the site Code $SiteCode = "P01" #provide the path list of packages to be Refreshed $packages =GC "C:\scripts\pkglist.txt" foreach ($package in $packages) { #Provide the DP server Name to be refreshed ON $Server = "CM12DP01" #host name is enough,no FQDN is required $pkgs = Get-WmiObject -Namespace "root\SMS\Site_$($SiteCode)" -Query "Select * From SMS_DistributionPoint WHERE PackageID='$Package' and serverNALPath like '%$Server%'" foreach ($pkg in $pkgs) {…
Author: Eswar Koneti
Running SQL queries directly from SQL server management studio is not safe method until you know what you are doing but it is always Good to use reporting services in Configmgr 2012. when you are running SQL code using SQL management studio,you get error something like below due to insufficient privileges on the selected Database: The SELECT permission was denied on the object ‘v_PackageStatusRootSummarizer’, database ‘CM_P01′, schema ‘dbo’. Permission was denied because you do not have enough read permissions to execute the query against the database. Get the read permissions on the selected Database from your Configmgr admin team. How…
Simple and useful report for troubleshooting package issues: Package compliance Status report to know what is the success rate of the Applications/Packages/Driver/SUP on the Distribution Points: select UPPER(SUBSTRING(PSD.ServerNALPath,13,CHARINDEX('.', PSd.ServerNALPath) -13)) AS [DP Name],count(*) [Targeted] , count(CASE when PSD.State='0' then '*' END) AS 'Installed', count(CASE when PSD.State not in ('0') then '*' END) AS 'Not Installed', round((CAST(SUM (CASE WHEN PSD.State='0' THEN 1 ELSE 0 END) as float)/COUNT(psd.PackageID ) )*100,2) as 'Success%', psd.SiteCode [Reporting Site] From v_PackageStatusDistPointsSumm psd,SMSPackages P where p.PackageType!=4 and (p.PkgID=psd.PackageID) group by PSd.ServerNALPath,psd.SiteCode order by 5 SSRS report looks like: To know list of failed packages on the…
Powershell Scripting made things lot more easier in Configuration Manager 2012.You can automate console operations by using Windows PowerShell cmdlets.For list of Configmgr SP1 cmdlets,refer http://technet.microsoft.com/en-us/library/jj821831(v=sc.10).aspx Manually Refresh of the Distribution Points for a specific package in Configmgr 2012 is not easy as it was in CM07. Started using the Powershell script for simple tasks such as Redistribute,updating,adding Distribution points. Use the below script to refresh failed package on Multiple Distribution Points. import-module F:\sccm\AdminConsole\bin\ConfigurationManager.psd1 $SiteCode = "ESK" $DPserver =GC "C:\Script\Servers.txt" foreach ($Server in $DPserver) { $PackageID = "ESK00001" $distpoints = Get-WmiObject -Namespace "root\SMS\Site_$($SiteCode)" -Query "Select * From SMS_DistributionPoint WHERE…
Quick Post: You have created an Application in Configmgr 2012 and distributed to Distribution Points.Later for reason,you have decided to add/change/Update the files to the package source location. In Configmgr 2007,we do this by right click package, Update the package,which will take the changes to All Distributed Sites. In Configmgr 2012,The option is replaced with deployment Type means ,you can have multiple deployment types (Both Local install and Virtual package) for single application. Go to your application in Configmgr console,Click on the application,Underneath you see the options like summary,deployment types and deployments choose what deployment you made changes, Right click…
Reporting in Configuration Manager 2012 and later, is Replaced with SSRS with more features and little complicated if you have not used to it. In this blog post, we will see how to check the status of the packages with their distribution status. To know the Status of content (Packages) ,you can look at monitoring Node—>Distribution Status—>Content But somehow i did not like view to go every time (I feel it takes much time to load all the packages) to know the distribution status of all applications such as apps, packages, software update packages etc created in configuration manager. I…
Did you ever get into disk Space Issues while copying,Decompressing PCK files in Configuration Manager 2007 ? Packages are failed due to not enough disk space ? couple of options to get out of it are 1) Add Extra Drives or Increase the Disk on the Drive if you are into VM 2) manage with the existing disk by doing some alteration to it like moving the PCK files or Delete them. OR Move to Configuration manager 2012 which no longer use PCK storage and uses Single Instance Storage ,More about why should move from CM07 to CM12 http://eskonr.com/2013/01/why-should-we-move-from-sccm-configmgr-2007-to-2012/ and…
In my earlier post,we saw how to manage work group computers using SCCM Configmgr 2007. http://www.windows-noob.com/forums/index.php?/topic/2029-managing-workgroup-computers-in-sccm-sms-environment/ In this blog post,we are going to see how to manage workgroup/ DMZ computers using SCCM Configmgr 2012. This procedure involves working with lmhost and host files on workgroup computers. For some reason,i find that ,Technet documentation is not very clear on how to manage workgroup computers http://technet.microsoft.com/en-us/library/bb680962.aspx. Technet document just illustrates the overall procedure but not in detail. Before we jump into the details of updating lmhost,other files,lets have a look at workgroup limitations,site assignment,approval etc. There are some limitation while managing the workgroup computers…