How To create Collection target ALL Office version

How To create Collection target ALL Office version:

Office 2013:

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceID where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Microsoft Office Professional Plus 2013"


Office 2010 :

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceID where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Microsoft Office Professional Plus 2010"

Office 2007 :

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceID where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Microsoft Office Enterprise 2007"

Office 2003 :

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceID where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Microsoft Office Professional Edition 2003"

ALL Windows Version Numbers

ALL Windows Version Numbers:

Operating System	Version / Build / Date
Windows 95 OEM Service Release 1 (95A)	4.00.950 A *)
Windows 95 OEM Service Release 2 (95B)	4.00.1111 B *)
Windows 95 OEM Service Release 2.1	4.03.1212-1214 B *)
Windows 95 OEM Service Release 2.5 C	4.03.1214 C *)
Windows 98	4.10.1998
Windows 98 Second Edition (SE)	4.10.2222 A
Windows Millenium Beta	4.90.2476
Windows Millenium	4.90.3000
Windows NT 3.1	3.10.528 (27.07.1993)
Windows NT 3.5	3.50.807 (21.09.1994)
Windows NT 3.51	3.51.1057 (30.05.1995)
Windows NT 4.00	4.00.1381 (24.08.1996)
Windows NT 5.00 (Beta 2)	5.00.1515
Windows 2000 (Beta 3)	5.00.2031
Windows 2000 (Beta 3 RC2)	5.00.2128
Windows 2000 (Beta 3)	5.00.2183
Windows 2000	5.00.2195 (17.02.2000)
Whistler Server Preview	2250
Whistler Server alpha	2257
Whistler Server interim release	2267
Whistler Server interim release	2410
Windows XP (RC 1)	5.1.2505
Windows XP	5.1.2600 (25.10.2001)
Windows XP, Service Pack 1	5.1.2600.1105-1106
Windows XP, Service Pack 2	5.1.2600.2180
Windows XP, Service Pack 3	5.1.2600 (21.04.2008)
Windows .NET Server interim	5.2.3541
Windows .NET Server Beta 3	5.2.3590
Windows .NET Server Release Candidate 1 (RC1)	5.2.3660
Windows .NET Server 2003 RC2	5.2.3718
Windows Server 2003 (Beta?)	5.2.3763
Windows Server 2003	5.2.3790 (24.04.2003)
Windows Server 2003, Service Pack 1	5.2.3790.1180
Windows Server 2003	5.2.3790.1218
Windows Home Server	5.2.3790 (16.06.2007)
Windows Longhorn	6.0.5048
Windows Vista, Beta 1	6.0.5112 (20.07.2005)
Windows Vista, Community Technology Preview (CTP)	6.0.5219 (30.08.2005)
Windows Vista, TAP Preview	6.0.5259 (17.11.2005)
Windows Vista, CTP (Dezember)	6.0.5270 (14.12.2005)
Windows Vista, CTP (Februar)	6.0.5308 (17.02.2006)
Windows Vista, CTP (Refresh)	6.0.5342 (21.03.2006)
Windows Vista, April EWD	6.0.5365 (19.04.2006)
Windows Vista, Beta 2 Previw	6.0.5381 (01.05.2006)
Windows Vista, Beta 2	6.0.5384 (18.05.2006)
Windows Vista, Pre-RC1	6.0.5456 (20.06.2006)
Windows Vista, Pre-RC1, Build 5472	6.0.5472 (13.07.2006)
Windows Vista, Pre-RC1, Build 5536	6.0.5536 (21.08.2006)
Windows Vista, RC1	6.0.5600.16384 (29.08.2006)
Windows Vista, Pre-RC2	6.0.5700 (10.08.2006)
Windows Vista, Pre-RC2, Build 5728	6.0.5728 (17.09.2006)
Windows Vista, RC2	6.0.5744.16384 (03.10.2006)
Windows Vista, Pre-RTM, Build 5808	6.0.5808 (12.10.2006)
Windows Vista, Pre-RTM, Build 5824	6.0.5824 (17.10.2006)
Windows Vista, Pre-RTM, Build 5840	6.0.5840 (18.10.2006)
Windows Vista, RTM (Release to Manufacturing)	6.0.6000.16386 (01.11.2006)
Windows Vista	6.0.6000 (08.11.2006)
Windows Vista, Service Pack 2	6.0.6002 (04.02.2008)
Windows Server 2008	6.0.6001 (27.02.2008)
Windows 7, RTM (Release to Manufacturing)	6.1.7600.16385 (22.10.2009)
Windows 7	6.1.7601
Windows Server 2008 R2, RTM (Release to Manufacturing)	6.1.7600.16385 (22.10.2009)
Windows Server 2008 R2, SP1	6.1.7601
Windows Home Server 2011	6.1.8400 (05.04.2011)
Windows Server 2012	6.2.9200 (04.09.2012)
Windows 8	6.2.9200 (04.09.2012)
Windows Phone 8	6.2.10211 (29.10.2012)

how to create collection target ALL IE Version

how to create collection target ALL IE Version  :
IE :11
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FilePath like "%\\Program Files\\Internet Explorer\\" and SMS_G_System_SoftwareFile.FileName like "iexplore.exe" and SMS_G_System_SoftwareFile.FileVersion like "11%"

IE :10
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceID inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceID where SMS_G_System_SoftwareFile.FilePath like "%\\Program Files\\Internet Explorer\\" and SMS_G_System_SoftwareFile.FileName like "iexplore.exe" and SMS_G_System_SoftwareFile.FileVersion like "10%"

IE : 9
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceID inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceID where SMS_G_System_SoftwareFile.FilePath like "%\\Program Files\\Internet Explorer\\" and SMS_G_System_SoftwareFile.FileName like "iexplore.exe" and SMS_G_System_SoftwareFile.FileVersion like "9.%"

IE : 8
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FilePath like "%\\Program Files\\Internet Explorer\\" and SMS_G_System_SoftwareFile.FileName like "iexplore.exe" and SMS_G_System_SoftwareFile.FileVersion like "8%"


if you want add specific operating system link as   Windows 7 add :

and SMS_G_System_OPERATING_SYSTEM.Version like "6.1%"

Ex:
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceID inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceID where SMS_G_System_SoftwareFile.FilePath like "%\\Program Files\\Internet Explorer\\" and SMS_G_System_SoftwareFile.FileName like "iexplore.exe" and SMS_G_System_SoftwareFile.FileVersion like "9.%" and SMS_G_System_OPERATING_SYSTEM.Version like "6.1%"

how to create collection target IIS Servers

how to create collection target IIS Servers  :



select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SERVICE.Name = "W3SVC" and SMS_G_System_SYSTEM.SystemRole = "Server" order by SMS_R_System.IPSubnets

how to create collection target on DHCP And DNS Servers

how to create collection target on DHCP And DNS Servers  :

DHCP:

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SERVICE.Name = "DHCPServer" and SMS_G_System_SYSTEM.SystemRole = "Server" order by SMS_R_System.IPSubnets


DNS  :

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SERVICE.Name = "DNS" and SMS_G_System_SYSTEM.SystemRole = "Server" order by SMS_R_System.IPSubnets

create collection to target IP Range (WQL query )

create collection to target IP Range (WQL query )


select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.IPSubnets = "IP" or SMS_R_System.IPSubnets = "IP"


you can add More Ips just add or SMS_R_System.IPSubnets = "IP"

create collection to target Active directory OU (WQL query )

create collection to target Active directory OU (WQL query )


select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.SystemOUName   like "you Domain Name/OU Name"