Microsoft Endpoint Configuration Manager

System Center configuration Manager ya da yeni ismi ile Microsoft Endpoint Configuration Manager yönetim yazılımında sorgu bazlı koleksiyon oluşturmak isterseniz aşağıdaki örneklerden faydalanabilirsiniz.

Bilgisayar İsimlerine Göre

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 MS_R_System where SMS_R_System.Name like "%ORT%"

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 MS_R_System where SMS_R_System.Name like "%ORT%"

Windows Cluster Hizmeti Yüklü Sunucular

select * 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.Name = "ClusSvc"

select * 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.Name = "ClusSvc"

Hyper-V Rolü Yüklü Bilgisayarlar

select * 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.Name = "vmms"

select * 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.Name = "vmms"

DHCP Sunucuları

select * 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.Name = "DHCPServer"

select * 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.Name = "DHCPServer"

IIS Rolü Yüklü Bilgisayarlar

select *  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.Name = "W3SVC"

select * 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.Name = "W3SVC"

Windows 11 23H2

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.BuildNumber = "22631"

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.BuildNumber = "22631"

Windows 11 22H2

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.BuildNumber = "22621"

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.BuildNumber = "22621"

Windows 11 21H2

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.BuildNumber = "22000"

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.BuildNumber = "22000"

Windows 11 Enterprise

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 11 Enterprise"

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 11 Enterprise"

Windows 11 Pro

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 11 Pro"

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 11 Pro"

Windows 10 22H2

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 inner join 
SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SYSTEM.SystemRole = "Workstation" and SMS_G_System_OPERATING_SYSTEM.Version = "10.0.19045"

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 inner join

SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SYSTEM.SystemRole = "Workstation" and SMS_G_System_OPERATING_SYSTEM.Version = "10.0.19045"

Tüm Notebook Bilgisayarlar

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","11", "12", "14","18","21")

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","11", "12", "14","18","21")

Tüm Masaüstü Bilgisayarlar

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 ( "3", "4", "5","6", "7", "15","16")

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 ( "3", "4", "5","6", "7", "15","16")

Windows 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_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where 
SMS_G_System_OPERATING_SYSTEM.Caption like "Microsoft Windows 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_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where

SMS_G_System_OPERATING_SYSTEM.Caption like "Microsoft Windows 11%"

Windows 10 2004 21H2 Sürümü

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 inner join 
SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where 
SMS_G_System_SYSTEM.SystemRole = "Workstation" and SMS_G_System_OPERATING_SYSTEM.Version = "10.0.19044"

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 inner join

SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where

SMS_G_System_SYSTEM.SystemRole = "Workstation" and SMS_G_System_OPERATING_SYSTEM.Version = "10.0.19044"

Windows 10 2004 21H1 Sürümü

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 inner join 
SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where 
SMS_G_System_SYSTEM.SystemRole = "Workstation" and SMS_G_System_OPERATING_SYSTEM.Version = "10.0.19043"

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 inner join

SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where

SMS_G_System_SYSTEM.SystemRole = "Workstation" and SMS_G_System_OPERATING_SYSTEM.Version = "10.0.19043"

Windows 10 2004 20H2 Sürümü

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 inner join 
SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where 
SMS_G_System_SYSTEM.SystemRole = "Workstation" and SMS_G_System_OPERATING_SYSTEM.Version = "10.0.19042"

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 inner join

SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where

SMS_G_System_SYSTEM.SystemRole = "Workstation" and SMS_G_System_OPERATING_SYSTEM.Version = "10.0.19042"

Continue reading →

Ortaç DEMİREL

MCT

Tag Archives: Microsoft Endpoint Configuration Manager

SCCM Sorgu Bazlı Koleksiyon Listesi