Skip to content

WQL version less than string

Featured Replies

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

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.