Create SCCM collection based on Model and BIOS Version

Question

I need to create sccm device collection where model is dell 5400 but running BIOS version above 1.7.

I try below query but it didnt work after adding the BIOS version.

select distinct 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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Model = "Latitude 5400" and SMS_G_System_PC_BIOS.Name > "1.7"

Answer 1

Is what is in Name the version? i.e. .... did you use the right field?

PC_BIOS.Name > "1.7"

Answer 2

Why? What do you get? Also keep in mind the bios version is a string not a number.

Answer 3

Are you looking for version or Name? try with the following.
SMS_G_System_PC_BIOS.Version > "1.7"