FortiClient - Out of Date Report

[JarradW]

Can someone please help clean up the current report I've put together from the forums?

https://www.lansweeper.com/forum/yaf_postst15168_Windows--Deployment-logs--Built-in.aspx#post51418
https://www.lansweeper.com/forum/yaf_postst13513_Reports-from-Deployment-Logs.aspx#post47765
https://www.lansweeper.com/forum/yaf_postst15977_Deployment-report-with-only-newest-entries.aspx#post53775

So far I've managed to include the following:
Computer Uptime
FortiClient under version 6.4*
Patch Status
Specific Asset Group

Would like to include:
Last successful deployment per asset and not a giant list of every packagename deployed against an asset..
RunMode i.e. System Account, Scanning Credentials, Currently Logged On

Any help would be appreciated as I've logged a support email to Support@lansweeper.com as well

Thanks

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Description,
  Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 /
  24))) + ' days ' +
  Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 %
  24))) + ' hours ' +
  Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) % 3600 /
  60))) + ' minutes' As Uptime,
  tblSoftwareUni.softwareName,
  tblSoftware.softwareVersion,
  tblSoftware.Installdate,
  Case
    When tblSoftware.softwareVersion < '6.4*' Then 'Out of Date'
    Else 'Up to Date'
  End As [Patch Status],
  tsysPackages.PackageName,
  tsysPackages.Timeout,
  tsysPackageLogs.Success,
  tsysIPLocations.IPLocation,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  Case
    When tblSoftware.softwareVersion < '6.4*' Then '#ffadad'
    Else '#d4f4be'
  End As backgroundcolor,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tsysPackages.PackageID
From tblAssets
  Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
  Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
      tblAssetGroupLink.AssetGroupID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join lansweeperdb.dbo.tblSoftware On tblAssets.AssetID =
      tblSoftware.AssetID
  Inner Join lansweeperdb.dbo.tblSoftwareUni On tblSoftwareUni.SoftID =
      tblSoftware.softID
  Inner Join lansweeperdb.dbo.tsysIPLocations On tsysIPLocations.LocationID =
      tblAssets.LocationID,
  lansweeperdb.dbo.tsysPackages,
  lansweeperdb.dbo.tsysPackageLogs
Where tblSoftwareUni.softwareName Like '%FortiClient%' And
  tsysPackages.PackageName = 'Upgrade FortiClient' And
  tblAssetGroups.AssetGroup = 'Kew - Unit 1 - Computers'
Order By tblAssets.Description,
  tblAssets.IPNumeric