You have Username but unsure what is their computer name where they logged into to track it(this all happens if…
Browsing: SQL Queries
create reports for the requirement and i first start analyzing the necessity and find the information about the required…
This blog post will help you to identify packages (count) for which there is no advertisement created and not used…
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…