This blog post will help you to identify packages (count) for which there is no advertisement created and not used…
Browsing: SQL Queries
In a Big environment to know/work based on regional wide kind of doing some maintenance tasks in SCCM ,this would…
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…