title: SCCM Query Filter
body: <p>I am trying to write a query in SCCM to look for .Net Framework that is less than a certain version.  </p>
  
  <p><strong>What I have:</strong></p>
  
  <pre><code>select distinct SMS_R_System.Name from  SMS_R_System where SMS_R_System.Name not in (select distinct SMS_R_System.Name from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceId = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Microsoft .NET Framework 4.6.2")
  </code></pre>
  
  <p>This shows everything not named 4.6.2. I want it to display everything less than 4.6.2. Also, when the query is ran, it shows only the machine name. What is the best way to display not just the machine name, but what version is installed?</p>