Author: Eswar Koneti

Configmgr 2012 allow admins to specify the Client Settings at collection level to control the behavior and functionality of the clients. You can create as many number of Custom Client Device/User settings (9999) which you can apply onto collections(Device/User). What happens if client is member of multiple collections that have client settings ? All the Custom Client settings that you create are chosen with the priority. Higher the priority(1) will take over the settings with lower priority(10000). If you are going to have multiple client agent settings,focus attention else you will see undesired results. By Default,Configmgr will Configure default client…

If you are using User Device Affinity--associating a user with one or more specified devices  for application deployment to make sure the application install on all devices that are associated with that user,it is necessary to identify the computers which do not have primary User Defined.More about User Define Affinity http://technet.microsoft.com/en-us/library/gg699365.aspx. Create collection using below WQL query for list of computers with Primary Device is NULL.(Make sure you limit the collection to computers with Client installed and Active) else you will get all computers who do not have sccm client installed . WQL query uses wmi class (SMS_UserMachineRelationship) which store…

Recently there was a question asked in the forum about 'How to get list of applications ,packages assigned to specific collection with its deployment settings like user experience ,Deployment action like install or uninstall etc' . If you are in need of identifying the list of applications or packages deployed to specific collection with its deployment properties, this post is for you. To find list of applications with deployment type properties ,i looked at the default reports ,there isn't it any with this requirement,so started looking at my SCCM Configmgr SQL views documentation to find out the relevant SQL views…

While Upgrading Clients from Configmgr 2007 to Configmgr 2012,we see lot of issues with respect to client failure like client is installed with exit Code ‘0’ but software center do not work as intended,client is installed but no policies etc. I had interesting issue recently during the client up-gradation from CM07 to CM12.Client was installed successfully with Exit code ‘0’ from ccmsetup.log(%windir%\ccmsetup\logs) but software center doesn’t open. If I look at the properties of configuration manager applet,actions tab,I can see only 2 policies appearing(Machine and User) .locationservices.log and clientlocation.log,clientIDmanagerstartup.log show positive information,there are no errors but still unable to launch…

Recently,I was troubleshooting configmgr 2012 client issue ,the installation keeps failing with error code :1603 (from ccmsetup.log) ,error says ,”Fatal error during installation”. in addition to this,I see something interesting about network access location %APPDATA%. MSI: Could not access network location %APPDATA%\. File C:\Windows\ccmsetup\{181D79D7-1115-4D96-8E9B-5833DF92FBB4}\client.msi installation failed. Error text: ExitCode: 1603 Action: CostFinalize. ErrorMessages: Could not access network location %APPDATA%\. Could not access network location %APPDATA%\. From CCMSETUP.Log: while installing sccm client,It requires to access the environmental variable %APPDATA% from registry location which are are corrupted/Changed for several reasons . How do I Fix it ? There is fix available…

Recently,After the Path Tuesday, None of the clients which are reporting to Primary Site did not perform a successful Scan (clients beneath secondary Site are working Good) .This leads me to look at the software update logs on the client to see what is going wrong. Since most of the clients directly reporting to Primary are having issues ,so thought of checking/troubleshoot this issue on the Primary site itself . Browse through the wuahandler.log from Drive:\Configmr\SMS_CCM\Logs,below is what I can see. OnSearchComplete - Failed to end search job. Error = 0x80244022. Scan failed with error = 0x80244022. To know the…

Year ago,I created CM07 report to know the patch compliance stats for active patches last 30 days.More info can be found from here.But this report was for configuration manager 2007 which will not work with Configmgr 2012 due to the changes in storing the information in SQL tables/Views. I have created similar report for configuration manager 2012.This report will list down all active patches which are deployed during last 30 days .I have used the criteria to filter the days using patch released date(DateCreated). SQL Code Used in SSRS Report: select UI.Title, UI.BulletinID,CS.NumPresent as Installed,CS.NumMissing as Missing,CS.NumFailed [Failed], CS.NumNotApplicable as…

This is updated post for long ago blogged post http://eskonr.com/2010/04/sccm-reportcollection-for-computers-with-internet-explorer-with-different-versions/. are you in search of getting summary of IE Versions ,so that you can plan for the migration of Old IE Versions to current version ? Below is the SSRS/SQL report which will help you to get count of IE Versions and total. SQL Query used in Report(if you are still running on SCCM 2007): select replace(left(SF.FileVersion,2), '.','') as 'IE Version', Count (Distinct SF.ResourceID) as 'Total' From dbo.v_GS_SoftwareFile SF Where SF.FileName = 'iexplore.exe' and SF.FilePath like '%Internet Explorer%' Group by replace(left(SF.FileVersion,2), '.','') Order by 2 desc Note:Replace the quotes with…