Jump to content

Sign in to follow this  
Adam Bise

WQL version less than string

Recommended Posts

I want to create a collection using WQL to include computers with PC Bios SMBIOS BIOS Version "less than" 2.18.6.

Problem is the version is a string and the less than operator uses sort order for strings so I wind up with machines with BIOS version 2.5.9 being GREATER than 2.18.6

I did find this post https://social.technet.microsoft.com/Forums/en-US/aacdcbda-6d14-4adb-b032-c9034d975403/querying-for-version-number-baseline?forum=configmanagergeneral

My question is, would this be the best approach?  Is there a simpler regex query I could use to achieve the same result?


Thank you

Share this post

Link to post
Share on other sites

The better option is to use the ReleaseDate property, which is a datetime value.

  • Thanks 1

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this