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…

SCCM report for Domain Controllers with RAM,Operating System,IP Address etc. Full Details : http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/0dedf567-7bbd-4c36-bc7a-12c409a79618 SELECT       sys.Name0 AS 'System Name',       os.Caption0 AS 'Operating System',       os.CSDVersion0 AS 'Service Pack',       PM.TotalPhysicalMemory0 /1024 as 'RAM in MB',       OS.InstallDate0 AS 'Original OS Install Date',       os.LastBootUpTime0 AS 'Last Boot Time',       NAC.IPAddress0 AS 'IP Address',…

  Report provide count of computers from the collections. Full Details: http://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/thread/f0cccbd7-7616-4d06-a3a6-31d4c583e2f0 SELECT v_Collection.Name ,v_Collection.Comment,v_Collection.CollectionID,COUNT(*) as [Members] FROM v_Collection,v_FullCollectionMembership where v_Collection.CollectionID=v_FullCollectionMembership.CollectionID group by v_Collection.Name ,v_Collection.Comment,v_Collection.CollectionID order by v_Collection.Name

Having multiple sites and checking the status of WSUS synchronization on all servers tedious job and child sites must sync with its parent sites to ensure right compliance levels from clients. This report will give you the status of WSUS server with Right content version. When SCCM sync with Microsoft Updates,Content version will get increment…
SCCM Report status of Packages used in Task Sequence

Another Interesting report which will help you to identify if there are any packages used in Task Sequence are not available on Distribution Points. If the Reference packages used in Task Sequence not available on DP,your Task sequence will fail and then u come back to fix the issues so lets be proactive . SCCM…
SCCM report Count Status of packages on All Distribution Points

In my previous report,we saw complete information about Pending packages,installed packages,Targeted but not installed,total packages targeted to DP http://eskonr.com/2012/08/sccm-report-count-of-packages-available-on-distribution-points/ In todays report,we go with count of all packages information at one glance to identify and Fix total number of Packages Distributed out of which how many are installed,Pending Packages. select dbo.v_SystemResourceList.Servername as "Server Name", (select…