query windows client and version for collection

Question

Hello,

I would like to know if there is a better query to filter on computer/server OS version to dynamically build collection.

my sample for w10 2004:

  select * 
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_OPERATING_SYSTEM.BuildNumber = "19041" and SMS_G_System_SYSTEM.SystemRole = "Workstation"

my sample for server 2019:

select *    
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_OPERATING_SYSTEM.BuildNumber = "17763" and SMS_G_System_SYSTEM.SystemRole = "Server"

Thank you for your answer.

Answer 1

Thank you for your answer.

IsVirtualMachine seems to have false positive on my environment lab.
I have only 1 host with vmware virtual machine and I can see some report true on "isvirtualmachine" and some report "false". I don't understand why....

I suppose I can use this to find if it's VM or not with good filter (vmware / hyper-v / ...)