how To Test Management Point in SCCM 2012

how To Test Management Point in SCCM 2012 is working fine



1. Verify MPsetup.log. Make sure MP is install successfully, if not resolve the problem. If you find any problem in MPSetup.log, then verify MPMSI.log 

2. Check IIS and make sure that you have virtual directory named SMS_MP under default website.

3.Check mpcontrol.log and find if you have below sucesses status message

4. Fianlly for testing run this on IE from any client and from the server itself and you sould get the results mentioned. 

  a) Run http://<MP Name>/sms_mp/.sms_aut?mplist

   This returns a list of MP's installed on this site including the secondary site MP's. 

  b) Run http://<MP Name>/sms_mp/.sms_aut?mpcert


For More Information

http://technet.microsoft.com/en-us/library/cc180197.aspx
http://technet.microsoft.com/en-us/library/cc180195.aspx 

create collection For Hyper-V and service

Hyper-v


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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Model like "Virtual Machine"



For service :

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  where SMS_G_System_SERVICE.DisplayName like "Hyper-V Virtual Machine Management"

create Collection For Servers Not Rebooted before 30 Days

create Collection For Servers Not Rebooted before 30 Days  :


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_OPERATING_SYSTEM ON SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId    WHERE (SMS_G_System_OPERATING_SYSTEM.Caption like "%2003%" or SMS_G_System_OPERATING_SYSTEM.Caption like "%2008%")   and (DateDiff(day, SMS_G_System_OPERATING_SYSTEM.LastBootUpTime, GetDate()) >30)

create collection For any Virtual Machines

create collection For any Virtual Machines   :

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_COMPUTER_SYSTEM on   SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId   where SMS_G_System_COMPUTER_SYSTEM.Model like "%Virtual%"

create collection For Vmware servers

create collection  For VMWare 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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Model like "VMware Virtual Platform"

how to create collections For All Window Server

how to create collections For All Window Server :
1- For any windows server

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 OperatingSystemNameAndVersion like 'Microsoft Windows NT%Server%'


2- Windows server 2012

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_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Version = "6.2.9200" and SMS_G_System_OPERATING_SYSTEM.Name like "%server%"


3- windows server 2008 R2

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.OperatingSystemNameandVersion like "%Server 6.1%" or SMS_R_System.OperatingSystemNameandVersion like "%Server 6.1%" or SMS_R_System.OperatingSystemNameandVersion like "Microsoft Windows NT Server 6.1"


4- windows server 2008

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 OperatingSystemNameAndVersion like "Microsoft Windows NT%Server 6.0%"


5- windows server 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 where OperatingSystemNameandVersion like '%Server 5.2%'

how to create collection to computers without LastHardwareScan and LastSoftwareScan

here you can change the data as you like for my Ex :
STATUS.LastHardwareScan, Getdate()) > 60  
LastSoftwareScan.LastScanDate, Getdate()) > 30

also if you want Hardware only you can delete


    and Datediff(DD,SMS_G_System_LastSoftwareScan.LastScanDate, Getdate()) > 30


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       inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId       inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId       inner join SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS.ResourceId = SMS_R_System.ResourceId       inner join SMS_G_System_LastSoftwareScan on SMS_G_System_LastSoftwareScan.ResourceId = SMS_R_System.ResourceId   where       SMS_G_System_SYSTEM.SystemRole = "Workstation"       and SMS_G_System_COMPUTER_SYSTEM.Model != "%Virtual%"       and Datediff(DD,SMS_G_System_WORKSTATION_STATUS.LastHardwareScan, Getdate()) > 60       and Datediff(DD,SMS_G_System_LastSoftwareScan.LastScanDate, Getdate()) > 30

SQL Report For Collect Computer or server model and Manufacturer

SQL Report For Collect Computer or server model and Manufacturer :


select
GSCS.Manufacturer0 as [Manufacturer],
GSCS.Model0 as [Model],
count(*) as [Count]
from v_R_System RS
left join v_GS_COMPUTER_SYSTEM GSCS on RS.ResourceID = GSCS.ResourceID
Group by GSCS.Model0, GSCS.Manufacturer0
Order by GSCS.Model0

SQL Report For Collect Specific Product With MAC And Ip address

Select distinct SYS.Netbios_Name0, SYS.User_Name0, SP.ProductName, SP.CompanyName, SP.ProductVersion ,V.MAC_Addresses0,I.ipaddress0
FROM fn_rbac_GS_SoftwareProduct(@UserSIDs)  SP
JOIN fn_rbac_R_System(@UserSIDs)  SYS on SP.ResourceID = SYS.ResourceID
INNER Join v_RA_System_MACAddresses V ON V.ResourceID=SYS.ResourceID
INNER Join dbo.v_GS_NETWORK_ADAPTER_CONFIGUR I ON I.ResourceID=SYS.ResourceID
WHERE SP.ProductName = @variable
Order by SP.ProductName, SP.ProductVersion



if any one need more Information ,kindly contact with me

how to create collection for collect Laptop Machines

how to create collection for collect Laptop Machines :
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 inner join SMS_G_System_SYSTEM_ENCLOSURE on SMS_G_System_SYSTEM_ENCLOSURE.ResourceID = SMS_R_System.ResourceID where SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes in ( "8", "9", "10", "14" )

how to create collection For collect Desktop Machines

how to create collection For collect Desktop Machines :


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_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Caption = "Microsoft Windows 7 Enterprise" or SMS_G_System_OPERATING_SYSTEM.Caption = "Microsoft Windows 7 Professional" or SMS_G_System_OPERATING_SYSTEM.Caption = "Microsoft Windows 7 Ultimate" or SMS_G_System_OPERATING_SYSTEM.Caption = "Microsoft Windows 8 Enterprise" or SMS_G_System_OPERATING_SYSTEM.Caption = "Microsoft Windows 8 Enterprise N" or SMS_G_System_OPERATING_SYSTEM.Caption = "Microsoft Windows 8 Pro" or SMS_G_System_OPERATING_SYSTEM.Caption = "Microsoft Windows XP Professional" or SMS_G_System_OPERATING_SYSTEM.Caption = "Microsoft® Windows Vista™ Business"

how to create collection target on specific Manufacturer Like (Dell & Hp )

how to create collection target on specific Manufacturer Like (Dell & Hp ) :
WQL Query :

For Example : dell Manufacturer

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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceID where SMS_G_System_COMPUTER_SYSTEM.Manufacturer like "Dell%"

create collection for Duplicate Computer Names

create collection for Duplicate Computer Names :

WQL Query :

select R.ResourceID,R.ResourceType,R.Name,R.SMSUniqueIdentifier,R.ResourceDomainORWorkgroup,R.Client from SMS_R_System as r  full join SMS_R_System as s1 on s1.ResourceId = r.ResourceId  full join SMS_R_System as s2 on s2.Name = s1.Name  where s1.Name = s2.Name and s1.ResourceId != s2.ResourceId

how to create collection to collect Your SCCM client version

how to create collection to collect Your SCCM client version :
after you upgrade your SCCM Server from sp1 to SCCM R2 . You facing SCCM R2 Client version is different so you need to now which computers client without update

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.ClientVersion = "SCCM Client version"

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 where SMS_R_System.ClientVersion = "5.00.7958.1000"

how to create collection For Unhealthy Clients

how to create collection For Unhealthy Clients:
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.Obsolete = 0 or SMS_R_System.Obsolete is null ) and SMS_R_System.SMSAssignedSites is not null  and (SMS_R_System.Client = 0 or SMS_R_System.Client is null )

How to create collection target ALL SQL Server Version

How to create collection target ALL SQL Server Version  :

SQL 2012 :

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 inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Microsoft SQL Server 2012%" and SMS_G_System_SYSTEM.SystemRole = "Server"


SQL 2008 :

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 inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Microsoft SQL Server 2008%" and SMS_G_System_SYSTEM.SystemRole = "Server"


BY Services :

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 = "MSSQLSERVER" and SMS_G_System_SYSTEM.SystemRole = "Server" order by SMS_R_System.IPSubnets

Note : if you apply it By services You will get all version .so You Should Create 2 Collection By version 2012 and 2008.
and limiting collection as the below screen

How To create Collection target Share Point

How To create Collection target Share Point   :

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 like "%SharePoint %"

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"