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: 74  
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 Automatic Follow-Up for Tickets
by  Francis Lee Mondia - Endace   Go to last post Go to first unread
Last post: Yesterday at 11:06:51 PM(UTC)
Lansweeper Can't see devices on Lansweeper
by  vqT4cDoP9iXyMZwoDUWU  
Go to last post Go to first unread
Last post: Yesterday at 8:33:21 PM(UTC)
Lansweeper LAPS managed password
by  SystemAdmin   Go to last post Go to first unread
Last post: Yesterday at 6:08:42 PM(UTC)
Lansweeper Install Adobe Reader Error
by  Brandon  
Go to last post Go to first unread
Last post: Yesterday at 2:46:54 PM(UTC)
Lansweeper Stop deployment
by  Tyler M.   Go to last post Go to first unread
Last post: Yesterday at 1:59:22 PM(UTC)
Lansweeper "Out of memory" in errorlog.txt
by  dua  
Go to last post Go to first unread
Last post: Yesterday at 1:00:42 PM(UTC)
Lansweeper Installation issues
by  Troy   Go to last post Go to first unread
Last post: Yesterday at 9:24:54 AM(UTC)
Lansweeper End of Life Asset Report
by  DJ Bradley  
Go to last post Go to first unread
Last post: 5/11/2021 4:09:33 PM(UTC)