cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
scottl
Engaged Sweeper
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.
1 ACCEPTED SOLUTION
MikeMc
Champion Sweeper II
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

View solution in original post

1 REPLY 1
MikeMc
Champion Sweeper II
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