cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
eclark82
Engaged Sweeper
I am trying to locate a report I can use to provide me with the current version of LSPUSH being used on the servers that I have it as a task.

Any assistance would be appreciated.

Thanks
1 REPLY 1
Esben_D
Lansweeper Employee
Lansweeper Employee
This report should work. It shows all assets which have been scanned by LsPush at some point and the LsPush version used during that last LsPush scan.

Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.LastLsPush,
tblAssets.LsPushVersion,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype,
tsysScanningMethods
Where tblAssets.LastLsPush Is Not Null And tblAssetCustom.State = 1