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…

Full details:http://social.technet.microsoft.com/Forums/systemcenter/en-US/82a7862a-fc1c-4c45-9635-ee44489c2673/file-inventory-report-query-by-name-count-and-machineid?forum=configmgrreporting   select cs.Name0 [Computer name],COUNT(*) as [No of Times] from v_GS_SoftwareFile SF,v_GS_COMPUTER_SYSTEM cs where FileName like '%.mdf%' and SF.ResourceID=cs.ResourceID group by cs.Name0 order by 2 desc