Full Details : http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/83aaf1dc-eaa9-4612-8ee2-a80020d79d0b select sys.Name0,OS.Caption0 from v_R_system sys inner join v_GS_OPERATING_SYSTEM OS ON os.resourceID=sys.resourceID where sys.ResourceId not in (select…
Browsing: sccm report
Here is nice report to identify computers which are with more than one partition installed on to them excludes external…
You have Username but unsure what is their computer name where they logged into to track it(this all happens if…
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…
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…