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…

Various methods to get the Uninstallation String for particular application.You can go with MOF changes to get uninstall string from registry(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall ) using Mark regkeytomof or You can use BDNA Normalize. Now aDays ,most of the organizations are converting Applications to MSI with more customizations with unattended installation  except some applications which has msi…

If you are Performing package cleanup,this query might help you to Identify how many packages with no advertisements(standard advertisement and Task Sequence) so you know What action to Take next! select  v_Package.PackageID, v_Package.Name,v_Package.SourceVersion,v_Package.SourceDate from dbo.v_package Where packageID not in (select PackageID from dbo.v_Advertisement)and PackageID not in (SELECT ReferencePackageID FROM v_TaskSequenceReferencesInfo) and v_Package.name not like '%osd%'…

In this post,we will see how to get heartbeat discovery (DDR) time for the clients from specific collection using Reports.For troubleshooting client health issues ,we need to know when was the client last reported its DDR . If you need to create collection to list the clients that are not sending heartbeat DDR for past…