Update: This post is updated after the Configmgr 2012 R2 CU1 hotfix released as this fix will resolve the subject line Issue. I recently had interesting issue with Configmgr 2012 SP1 CU3 client.Many Optional applications in Software Center changes to 4/10/1998 for  ‘Available After’ This issue was posted on several forums but there is no…

In my previous blog post,i talked about how to compare 2 distribution points to see if they both have any applications mismatch.This blog post talks about how to distribute the missing apps to the Distribution Point. I have used basic inbuilt Configmgr powershell commands for this activity,more via here Note:Use the package names as input…

Good news to Configmgr guys.Yesterday Microsoft announced another Free book called “Microsoft System Center: Troubleshooting Configuration Manager “ which talks about site hirarchy,distribution points,understanding configuration manager components,log files,troubleshooting scenarios. I think this guide will provide you to understand various components of Configuration Manager on both the server and client side work together while performing the…

Few Days ago,Microsoft released Cumulative Update 3 (supersedes Cumulative update 2 ) for Configuration Manager 2012 SP1 which has around 18 fixes related OSD,Powershell,Software Distribution etc. More about the hotfix and download refer http://support.microsoft.com/kb/2882125 Installation of Cumulative Update 3 on Configurations manager SP1 is straight forward.you would need to follow the steps,next,next ,done. This Cumulative…

Microsoft just released Cumulative Update 3 for System Center 2012 Configuration Manager (Configmgr) SP1.This update fixes issues on OSD,Powershell,Software Distribution,Windows In tune,Endpoint Protection,Site Systems,Reporting,Software Updates. Supported Platforms: This update adds support for Windows 8.1-based client computers in Microsoft System Center 2012 Configuration Manager Service Pack 1. Windows 8.1 is added to the supported platform list…
SCCM Configmgr report:Inventory for Webcam Devices ?

Inventory report for laptops who have webcam feature ? You can use this report both on SCCM 2007 and Configmgr 2012 Environment. select cs.name0 [Computer name], cs.username0 [Last loggedin User], os.Caption0 [OS],os.InstallDate0 [OS Installed Date], cs.Manufacturer0,cs.Model0 , WS.LastHWScan [Reported Date to SCCM] from v_GS_COMPUTER_SYSTEM cs,v_GS_SYSTEM_ENCLOSURE se,v_GS_OPERATING_SYSTEM OS,  v_GS_WORKSTATION_STATUS WS where cs.ResourceID=se.ResourceID and cs.ResourceID=OS.ResourceID and cs.ResourceID=WS.ResourceID…
SCCM Configmgr SQL Error The SELECT permission was denied on the object database CM_Sitecode-schema-dbo

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:…