Notification

Icon
Error

Report Request - List assets with old software when newer versions are found

Posted: Tuesday, April 13, 2021 8:34:35 PM(UTC)
Tyler M.

Tyler M.

Member Original PosterPosts: 25
1
Like
This issue has been solved! Click here to view the solution
Is it possible for somebody to make a report that would list computers with old versions of software if newer versions for that same software are found?

Right now I have a bunch of separate reports that tell me what computers have old versions of software. Only issue is that I have to manually check the softwares website to see if anything has been updated yet and if it has then manually edit the report to reflect the new version number. This is kind tedious and I would like to automate it a bit where I don't need to manually update it.

Example would be everybody has version 15.14 of 7-zip but if one person updates it to the latest version 19 then the report would list all the computers with the old version.

Would be awesome if the report shows Asset Name - Software - Old version number - New version number as well as the rest of the usual headers.

Hopefully I have explained it well enough for you all to understand and thanks in advance!
Andy.S
#1Andy.S Member Posts: 76  
posted: 4/20/2021 3:49:09 PM(UTC)
Hi Tyler M.

Have a look at this report by RC62N Using MAX for the software version :- https://www.lansweeper.c...-Outdated.aspx#post62681

I have amended the report to show just assets where Google is not the latest version found :


Code:
Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblSoftwareUni.softwareName As software,
  tblSoftware.softwareVersion As version,
  Case
    When tblSoftware.softwareVersion < MaxVersion.softwareVersion Then
      'Out of Date'
    Else 'Up to Date'
  End As [Patch Status],
  Case
    When tblSoftware.softwareVersion < MaxVersion.softwareVersion Then '#ffadad'
    Else '#d4f4be'
  End As backgroundcolor,
  tsysOS.Image As icon
From tblSoftware
  Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Join tblADusers On tblADusers.Username = tblAssets.Username And
    tblADusers.Userdomain = tblAssets.Userdomain,
  (Select Top 1 tblSoftware.softwareVersion
      From tblSoftware
        Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
      Where tblSoftwareUni.softwareName Like 'Google Chrome%' And
        tblSoftwareUni.SoftwarePublisher Like 'Google%'
      Order By tblSoftware.softwareVersion Desc) As MaxVersion
Where tblSoftwareUni.softwareName Like '%chrome%' And Case
    When tblSoftware.softwareVersion < MaxVersion.softwareVersion Then
      'Out of Date'
    Else 'Up to Date'
  End = 'Out Of Date'
Order By version,
  tblAssets.AssetName

Active Discussions

Lansweeper Creating a count
by  Brianne   Go to last post Go to first unread
Last post: Yesterday at 6:12:49 PM(UTC)
Lansweeper Some reports shows dublicated assets
by  Andy.S  
Go to last post Go to first unread
Last post: Yesterday at 9:46:37 AM(UTC)
Lansweeper Adding "multi-part" Conditions to Reports
by  Brandon   Go to last post Go to first unread
Last post: 5/13/2021 1:52:17 PM(UTC)
Report Center Microsoft Outlook email bug EX255650
by  Esben.D  
Go to last post Go to first unread
Last post: 5/12/2021 2:30:16 PM(UTC)
Lansweeper Patch Tuesday May 2021
by  Esben.D   Go to last post Go to first unread
Last post: 5/11/2021 8:13:06 PM(UTC)
Lansweeper Report showing only Wi-Fi Devices and MAC addresses
by  Andy.S  
Go to last post Go to first unread
Last post: 5/11/2021 2:23:24 PM(UTC)
Lansweeper Modifying Purchase Date / Yearly Refresh Report
by  Cripple.Zero  
Go to last post Go to first unread
Last post: 5/7/2021 7:06:47 PM(UTC)