Configmgr 2012 SSRS Report Count Client Versions

We have been seeing many hotfixes and Cumulative updates for configmgr 2012 product .For each hotfix /CU level,the client version will get change. As you test and deploy these hotfixes /CU's in your environment ,you are also required to maintain the environment both clients and server client to the same level as your site running.…
SCCM Report Applications packages assigned to specific collection with user experience settings

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…

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…
SCCM 2012 SSRS report Site Servers and its assigned boundary information

Quick post on the Boundaries and its assigned Site Servers which are nothing but Distribution Points.Simply creating boundaries does not make clients to get connected to DP and download the content. you will have create assign these boundaries to boundary group and boundary group to Site+Content location. Here is report to list all Boundaries and…

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

We have been seeing many hotfixes and Cumulative updates for configmgr 2012 product .For each hotfix /CU level,the client version will get change. As you test and deploy these hotfixes /CU's in your environment ,you are also required to maintain the environment both clients and server client to the same level as your site running.…
SCCM Configmgr 2012 How to deploy / Manage reports to specific Folder in report Manager

By Default,during the installation of reporting services role ,Configuration Manager 2012 will create and publish the reports to Configmgr_SiteCode (Ex:Configmgr_P01) Folder in Report Manager if you have not changed the default path name while installing Configuration Manager.   while the default reports always do not meet our needs in real time,it is required to create…

When you are doing Migration from SCCM 2007 to SCCM 2012,you may want to remove some of the drivers which are no longer needed . This report list all the drivers which are part of any driver package so you can take action on them before you migrate to SCCM Configmgr 2012. Full Details :http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c82cc16a-06b7-49ae-ac11-2f6399047b6a…