In a Big environment to know/work based on regional wide kind of doing some maintenance tasks in SCCM ,this would…
Browsing: SCCM Reports
This catagory contains list of sccm reports and its relevent information
If you are performing SCCM cleanup activity on packages,this might help you to identify if there are any packages still…
I had requirement to check for some specific packages if their programs are used in any other packages or…
Full Details : http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/188bb324-9217-4fa6-b814-06a3d353bf52 Boundary information (AD Site) added . select distinct v_GS_SYSTEM.Name0 as 'Computer Name',A.AD_Site_Name0, substring(AccountName0,charindex('Domain=',Accountname0)+8,(charindex('Name=',Accountname0)-charindex('Domain=',Accountname0)-10)) as 'Domain Name',…
Did you ever find difficulty in identifying the site system information when you have multi-tier hierarchy like central,multiple primary sites…
Long Ago have posted sccm report about all advertisements that are currently assigned to specific computer http://eskonr.com/2010/12/sccm-report-to-list-all-the-advertisement-that-are-currently-assigned-to-computer/ this post gives…
Previous report list the packages which are successfully distributed to Distribution Points http://eskonr.com/2012/06/sccm-report-total-number-of-packages-targeted-to-dp/ This post gives you more information about…
Full Detials : http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/cdfc6114-09d8-4e85-a51a-ca279a36454a SELECT v_Package.PackageID, Name, v_DistributionPoint.LastRefreshTime FROM v_Package INNER JOIN v_DistributionPoint ON v_Package.PackageID = v_DistributionPoint.PackageID WHERE v_DistributionPoint.ServerNALPath…