Author: Eswar Koneti

My Previous Blog post talks about How to know Client Cache folder size in your Environment using Custom MOF.What is you are deploying Larger packages or Your Cache size is full with applications and software updates ? By Default,Configuration Manager Client stores the Deployed packages (could be applications,Packages,Software updates etc) in C:\windows\SysWOW64\CCM\Cache (CM07) and C:\Windows\ccmcache(CM12). The Size of the Cache folder can be specified while installing SCCM Client using parameter SMSCACHESIZE .If you do not set this property while installing SCCM Client, the folder defaults to a maximum size of 5120 MB. The lowest value you can specify is 1…

Read More

By Default,Client Cache information is not collected by Configuration Manager.You should do some customizations to get it working. This blog post talks about how to create Custom MOF file and import into SCCM as custom hardware inventory class which will be applied onto clients as policy to get the information from WMI . Save the below code into file with file_name.mof. [ SMS_Report (TRUE), SMS_Group_Name ("SMS Advanced Client Cache"), SMS_Class_ID ("SMS_ADVANCED_CLIENT_CACHE"), Namespace ("\\\\\\\\.\\\\root\\\\ccm\\\\softmgmtagent") ] class CacheConfig : SMS_Class_Template { [ SMS_Report (TRUE), key ] String     ConfigKey; [ SMS_Report (TRUE) ] Boolean     InUse; [ SMS_Report (TRUE) ] String     Location; [ SMS_Report…

Read More

Quick Update from Microsoft about System Center 2012 R2 Preview is available for Download from MSDN /Evaluation(below). This prerelease version is not supported in a production environment and is for testing only.  This prerelease version does not support an upgrade from previous versions of System Center 2012 Configuration Manager. Install this prerelease version as a new installation of Configuration Manager. In addition, Configuration Manager does not support the import of objects between different versions of Configuration Manager. To know more about Release notes and Known Issues with SCCM 2012 R2 Preview Release http://technet.microsoft.com/library/dn236347.aspx I have just extracted all the direct download links…

Read More

I was trying to setup new Configuration Manager 2012 SP1 build on Windows server 2012 with SQL Server 2012 SP1 installed .Everything went fine except Windows server update services .It keeps saying error with restart needed.Here is what i got every time when i install WSUS after restart the server. Update: You can also refer the solution posted here : http://blogs.technet.com/b/heyscriptingguy/archive/2013/04/15/installing-wsus-on-windows-server-2012.aspx The request to add or remove features on the specified server failed. the operation cannot be completed because the server that you specified requires a restart. Why does it fail every time though server is restarted several times after…

Read More

Recently i worked on issue with SCCM Client.Many applications are Advertised in Run Advertised programs as Optional(Optional can be set either not having mandatory schedule or allow users to run independently while creating Advertisement ). But none of the applications are running successfully from RAP .So verified CAS.log ,Datatransfer.log to see if any issues with content downloading to cache but they do work it. Next to look execmgr.log : From this log,what i noticed is ,Client is able to download the content and start the program command line but it failed with error message: CreateProcess or CreateProcessAsUser failed to execute…

Read More

SQL Code used in SCCM Reporting to get list of Advertisements that are Mandatory! select adv.AdvertisementName as [Adv Name], adv.PresentTime as DistributionDate, pkg.Name as PackageName, pgm.ProgramName, coll.Name as CollectioName, adv.AdvertisementID from v_Advertisement adv join v_Package pkg on adv.PackageID=pkg.PackageID join v_Program pgm on adv.PackageID=pgm.PackageID and adv.ProgramName=pgm.ProgramName join v_Collection coll on adv.CollectionID=coll.CollectionID join v_ClientAdvertisementStatus stat on adv.AdvertisementID=stat.AdvertisementID where (adv.AssignedScheduleEnabled != 0 or adv.AdvertFlags & 0X720 != 0) group by adv.AdvertisementID, adv.AdvertisementName, adv.PresentTime, pkg.Name, pgm.ProgramName, adv.SourceSite, coll.Name order by adv.AdvertisementName SQL Code used in SCCM reporting to get list of advertisements that are Optional. select adv.AdvertisementName as [Adv Name], adv.PresentTime as DistributionDate, pkg.Name…

Read More

Do you remember the Powershell script posted by SCOMFAQ  to download required MMS 2012 Sessions last year Once again he come up with easy way to download all the required MMS 2013 sessions using Powershell script. This basically contains 2 power shell scripts : Create-MMS2013SessionFile.ps1 –> This file creates the sessions.txt file OR You can create sessions.txe and add all the Sessions codes for Ex:DC-B309.wmv and save the file. MMS2013_Downloader.ps1 –> This file downloads the sessions which you have given in sessions.txt file. Download the scripts from Sky drive,save it in one folder.I have listed out all SCCM Configmgr 2012…

Read More

Configuration Manager Queries SQL Server views in the Configmgr site database when retrieving the information displayed in reports .Configmgr database contains large information about computer,User related resource and other components as well. If you are looking for some particular information while creating reports and if you are not sure which table the information has,you will stuck there else you will have guess the table/view to get what is desired. SQL views contain the information you need for your reports to make reporting easier. I cont find any document or related resources for SCCM 2012 SQL views . Russ from Microsoft…

Read More