Tuesday 18 December 2018
Wednesday 28 November 2018
Sunday 25 November 2018
Friday 26 October 2018
Monday 15 October 2018
Friday 12 October 2018
Thursday 11 October 2018
Monday 8 October 2018
Sunday 7 October 2018
Friday 5 October 2018
Thursday 4 October 2018
Wednesday 3 October 2018
Tuesday 2 October 2018
Monday 1 October 2018
Sunday 30 September 2018
Saturday 29 September 2018
Thursday 27 September 2018
Wednesday 26 September 2018
Tuesday 25 September 2018
Monday 24 September 2018
Saturday 22 September 2018
Friday 21 September 2018
Tuesday 18 September 2018
Monday 17 September 2018
Saturday 15 September 2018
Tuesday 11 September 2018
Monday 10 September 2018
Wednesday 5 September 2018
Tuesday 4 September 2018
Monday 3 September 2018
Sunday 2 September 2018
Tuesday 28 August 2018
Monday 27 August 2018
Sunday 26 August 2018
Monday 20 August 2018
Sunday 19 August 2018
Thursday 16 August 2018
Sunday 12 August 2018
Saturday 4 August 2018
Monday 30 July 2018
Monday 23 July 2018
Thursday 19 July 2018
Wednesday 20 June 2018
SCCM Queries for Server 2016, 2012, 2008 and Windows 10
SCCM Queries for Server 2016 and Windows 10
For Windows 2016 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
where
SMS_R_System.OperatingSystemNameandVersion like "%Server%"
and
SMS_R_System.OperatingSystemNameandVersion like "%10.0%"
For Windows 2012 R2 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
where
SMS_R_System.OperatingSystemNameandVersion like "%Server%"
and
SMS_R_System.OperatingSystemNameandVersion like "%6.3%"
For Windows 2008 R2 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
where
SMS_R_System.OperatingSystemNameandVersion like "%Server%"
and
SMS_R_System.OperatingSystemNameandVersion like "%6.1%"
Query to Extract All 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 where SMS_R_System.Name like "US%"
and (SMS_R_System.OperatingSystemNameandVersion like "Microsoft Windows NT Server%"
or
SMS_R_System.OperatingSystemNameandVersion like "Microsoft Windows NT Advanced Server%"
or SMS_R_System.OperatingSystemNameandVersion like "%Server%")
For Windows 10 Workstation
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 "%Workstation%"
and
SMS_R_System.OperatingSystemNameandVersion like "%10.0%"
Subscribe to:
Posts (Atom)