cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
BFUser
Engaged Sweeper

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?

1 REPLY 1
francisswest
Champion Sweeper

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

 

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now