If you in environment where in the deployment of Application is User Based and you are sometimes getting issues if…
Browsing: SQL code
You have Username but unsure what is their computer name where they logged into to track it(this all happens if…
This blog post will help you to identify packages (count) for which there is no advertisement created and not used…
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…