Eswar Koneti's Blog

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 get every time when i install WSUS after Restart needed. “The request to add or remove…… Read Full Article »

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…… Read Full Article »

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…… Read Full Article »

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…… Read Full Article »

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…… Read Full Article »

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…… Read Full Article »

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…… Read Full Article »

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 &…… Read Full Article »

This is Continuation to previous post package archival process.up on the query results,I would not delete the packages from console directly rather i delete them from its assigned Distribution points and move them to Archive folder and let be there for sometime until for sometime incase if it is required. If you have large number…… Read Full Article »

Long ago ,written SCCM report to list packages not used for 6 months as part of Package Archival process http://eskonr.com/2012/11/sccm-configmgr-package-archival-process-cleanup-activity/ .This report tells you to take further action to clean or move to Archive folder to wait for some more months before it goes for Deletion. What next ? Delete these packages from Assigned DPs…… Read Full Article »