Author: Eswar Koneti

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

MMS 2013 is getting nearer , (Apr 4-Apr 8) with loads of technical sessions on newly released products with hands on lab. More info here From Apr 4-8,total of 300+ sessions happening on various technologies . Many folks who works on Configuration manager like me, look for what content catalog. Here is the pdf file listing out all SCCM 2012 related stuff which might help you to follow up . download MMS 2013 SCCM 2012 SP1 Content Catalog These configuration manager Sessions will generally be available for streaming around 24 hours after the session is complete. http://channel9.msdn.com/Events/MMS/2013?sort=sequential&direction=desc&term=Configuration%20Manager How to participate in…

Read More

If you are planning to migrate your SCCM 2007 environment to SCCM 2012,you may have to think about your packages,collections,OSD and other stuff. you cannot migrate all collections from SCCM 2007 to SCCM 2012.Couple of things to note before you migrate them. Points to note  on collection migration: 1. Collection can contain only either devices or users but not both. 2.  Every collection must have Limitation. 3.   Sub collections are no longer exists instead you have folders. blogged couple of posts on archiving/removing packages not been used for X days that will help you to not migrate them to…

Read More

How to add link URL or shortcut file to users desktop profile ? Easiest way to accomplish this task is with GPO(Group policy Object). If you want to accomplish this task using Configuration manager(SCCM),you can create simple VB script that does this job. Option Explicit dim path path=CreateObject("WScript.Shell").ExpandEnvironmentStrings("%UserProfile%\desktop") dim objFSO set objFSO=CreateObject("Scripting.FileSystemObject") If objFSO.FileExists(path & ("\eskonr.url")) = False Then objFSO.CopyFile "\\servername\folder name\eskonr.url", path & "\" end if Full Details http://social.technet.microsoft.com/Forums/en-US/configmgrswdist/thread/ba1647a1-0385-48a9-9e83-1fc5daa00976/#e9d4f330-500e-45db-b3e1-5e3954f50ea4

Read More