SCCM Query Bazlı Collectionlar İçin Örnekler ve OS Versiyonları

10 January, 2013

Clients

  • Microsoft Windows NT Workstation 5.1 ? Windows XP
  • Microsoft Windows NT Workstation 5.2 ? Windows XP x64
  • Microsoft Windows NT Workstation 6.0 ? Windows Vista
  • Microsoft Windows NT Workstation 6.1 ? Windows 7
  • Microsoft Windows NT Workstation 6.2 ? Windows 8

Servers

  • Microsoft Windows NT Server 4.0 ? Windows NT
  • Microsoft Windows NT Server 5.0 ? Windows Server 2000
  • Microsoft Windows NT Server 5.2 ? Windows Server 2003
  • Microsoft Windows NT Server 6.0 ? Windows Server 2008
  • Microsoft Windows NT Server 6.1 ? Windows Server 2008 R2
  • Microsoft Windows NT Server 6.2 ? Windows Server 2012

Gelelim Query’lere;

Windows XP

select sms_r_system.ResourceID,sms_r_system.ResourceType,sms_r_system.Name,sms_r_system.SMSUniqueIdentifier,sms_r_system.ResourceDomainOR

Workgroup,sms_r_system.Client from sms_r_system where OperatingSystemNameandVersion like ‘%Workstation 5.1%’
Windows Vista

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 ‘%Workstation 6.0%’
Windows 7

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 ‘%Workstation 6.1%’
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%’
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%’
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 ‘%Server 6.0%’
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 OperatingSystemNameandVersion like ‘%Server 6.1%’

2,455 total views, 2 views today

Leave a Comment

Previous post:

Next post: