Create collection base on Model and BIOS version Above 1.7

[lalajee 1]

I need to create a Collection based on Model and BIOS version above 1.7

 

I try following query but it doesnt show any machine. I have check few machine and I can see that BIOS version is 1.6.x

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"

 

[skissinger 5]

Did you mean to use name?

SMS_G_System_PC_BIOS.Name > "1.7"

[GarthMJ 125]

What exactly isn't working for you? 

Also remember that the BIOS version is a string not a number too.