LSPUSH Version

[eclark82]

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

[Esben_D]

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