title: Querying for software using SQL query in SCCM
body: <p>I am looking for specific pieces of software across our network by querying the SCCM Database. My problem is that, for various reasons, sometimes I can search by the program's name and other times I need to search for a specific EXE.</p>
  
  <p>When I run the query below, does it take 13 seconds to run if the where clause contains an AND, but it will run for days with no results if the AND is replaced with OR. I'm assuming it is doing this because I am not properly joining the tables. How can I fix this?</p>
  
  <pre><code>select vrs.Name0
  FROM v_r_system as vrs
  join v_GS_INSTALLED_SOFTWARE as VIS on VIS.resourceid = vrs.resourceid
  join v_GS_SoftwareFile as sf on SF.resourceid = vrs.resourceid
  
  where 
  VIS.productname0 LIKE '%office%' AND SF.Filename LIKE 'Office2007%'
  
  GROUP BY vrs.Name0
  </code></pre>
  
  <p>Thanks!</p>