cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
PeterJG
Champion Sweeper II
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)
2 REPLIES 2
sullivane
Champion Sweeper III
Thanks! I figured out a little, but more examples are always good.
PeterJG
Champion Sweeper II

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