SOLVED Query - Windows Server 2016 and Windows Server 2019

[Sokoban]

Hi
How will I do to create a Query to a SCCM collection for

• Windows Server 2016
• Windows Server 2019

Thanks in advance ;-)

Sokoban

 

[Garth]

you would create this just as you would any other collection.

what do you have now and what isn't working with it?

 

[Sokoban]

Hi Garth
The problem is that query Collection, both Windows Server 2016 and 2019 servers wants collect in the same 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.OperatingSystemNameandVersion like "%Server%"
and
SMS_R_System.OperatingSystemNameandVersion like "%10.0%"

**********************************************************
Sokoban

 

[Garth]

Look at OS Caption. Does that do what you need?

 

[Sokoban]

Yes I have to collect in the separate collections. Windows Server 2016 is in one and Windows Server 2019 is in the another...

 

[Garth]

but it is unclear do you look at the OS class attribute called caption? are they different? is so base your query off of that.

 

[Sokoban]

...You give me questions was an approach which all the time, you can or cannot help me?

 

[Garth]

by telling you where to looking is helping you. did you look at OS caption?
plus i'm no where near me lab, it is 4000 km away from me right now.

 

[Sokoban]

The soultion,

Windows Server 2016

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_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM.SystemRole = "Server" and SMS_G_System_OPERATING_SYSTEM.Version = "10.0.14393"

Windows Server 2019

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_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM.SystemRole = "Server" and SMS_G_System_OPERATING_SYSTEM.Version = "10.0.17763"

Thase case is now solved, thanks ;-)

Sokoban