Software Report - installed Software

[BFUser]

Good day!

I am trying to create a report
that lists all systems
on which the software version 24.1.113.0 or version 24.1.173.0 is present, but not version 24.3.61.0 or version 24.3.171.0 or version 24.3.182.0 or version 24.3.152.0.

How can I solve this?

[francisswest]

What is the software name itself?  I can try to help.  I've got a report that scans for any version of Chrome under 120, but it could be modified to specify versions exactly, rather than 'greater than' or 'less than' calls.

Left Join (Select tblsoftware.assetid,
      tblSoftwareUni.softwareName,
      tblsoftware.softwareVersion,
      Case
        When tblSoftwareUni.softwareName Like '%Google Chrome%' And
          ((Cast(ParseName(tblsoftware.softwareVersion, 4) As int) < 120) Or
          (Cast(ParseName(tblsoftware.softwareVersion, 4) As int) = 120 And
          Cast(ParseName(tblsoftware.softwareVersion, 2) As int) < 6099) Or
          (Cast(ParseName(tblsoftware.softwareVersion, 4) As int) = 120 And
          Cast(ParseName(tblsoftware.softwareVersion, 2) As int) = 6099 And
          Cast(ParseName(tblsoftware.softwareVersion, 1) As int) < 62)) Then 1
        Else 0
      End As [out of date],

Thats just a snippet with relevant info that you may be able to adapt.  I'm pretty busy at the moment, but if you can get me the exact software name, I can *try* to write that up for ya.

Thanks