If you have referred to my previous report linked report http://eskonr.com/2012/05/sccm-linked-report-count-of-computers-assigned-to-specific-ad-site/ this would be easier for you to go. You…
Browsing: SQL Queries
Full Details :http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/7b4d3810-a262-4c63-8dd6-7cc906b85941 select sys.name0,sys.AD_Site_Name0,FCM.SiteCode,ARP.DisplayName0,ARP.Version0,ARP.InstallDate0 from V_R_system sys inner join v_Add_Remove_Programs ARP on arp.resourceID=sys.ResourceID inner join v_FullCollectionMembership FCM on…
Today's post is going to listing down computers assigned to specific site with count and this will be linked to…
long ago have posted report on computers with SCCM report for Last logged on computer name with application installed or…
Usually when applications are installed,they wont repot to site server with installed software and its details why because the value…
SELECT b.Netbios_Name0, b.User_Name0, CASE WHEN a.FileVersion LIKE '11.%' THEN 'Office 2003' WHEN a.FileVersion LIKE '12.%' THEN 'Office 2007'…
SELECT COUNT(distinct ResourceID) as [Count], IP_Subnets0 as Subnet FROM dbo.v_RA_System_IPSubnets WHERE IP_Subnets0 NOT IN (SELECT IPSubnet…
had a requirement to see how many computer falls within the specific subnet. select a.name0,b.IP_Subnets0 from v_R_System a,dbo.v_RA_System_IPSubnets b where…