FileScan Report

[PeterJG]

The Custom scanning for files in lansweeper is great but the ability to user the reports isn't so here is example how you can create report using LSPUSH.exe version to report and run appropriate tasks in scheduler based on this report. I use this to update LSPUSH.exe on pc's using the after-scan option to deploy update package. In this example any version lower than 6.0.0.2 and all 5.x versions are reported on active assets

Select Top 1000000 tblAssets.AssetID,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetName,
  tblAssets.IPAddress,
  tblFileVersions.FilePathfull As Path,
  tblFileVersions.FileVersion As Version
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID
Where (tblFileVersions.FilePathfull Like '%lspush.exe%' And
  tblFileVersions.FileVersion Like '6.0.0.1%') Or
  (tblFileVersions.FileVersion Like '5.%' And tblAssetCustom.State = 1)

[sullivane]

Thanks! I figured out a little, but more examples are always good.

[PeterJG]

Select Top 1000000 tblAssets.AssetID,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetName,
  tblAssets.IPAddress,
  tblFileVersions.FilePathfull As Path,
  tblFileVersions.FileVersion As Version,
  tblAssetCustom.Model
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID
Where (tblFileVersions.FilePathfull Like '%lspush.exe%' And
tblFileVersions.FileVersion Like '6.0.0.2%' And tblAssetCustom.Model =
  'MODEL#')Or
  (tblFileVersions.FileVersion Like '5.%' And tblAssetCustom.State = 1)

Made changes to you can specify the model# and to do after scan unser Deployment /Schedule click "New Deployment Configuration" and select Execution "After Scanning" and pint source to this report