Report of outdated LSPush software

[scottl]

I have a number of workgroup computers with LSPush installed locally. I would like a report that shows all the computers that are reporting back with older versions of LSPush.

[MikeMc · Accepted solution]

I saw in the database that the software stores the latest LSPush version and the last LSPush version reportedly used with assets. For some reason, the software doesn't let you reference the latest value under the TsysConfig table.

Anyway, here is a query you can use but you'll have to change the file version to what your environment uses.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName
From tblAssets
  Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Where tblAssetCustom.State = 1 And tblAssets.LsPushVersion <> '6.0.0.11'
Order By tblAssets.AssetName