LSPUSH Deployment

[marrngtn]

How can I report on clients being updated via LSPUSH?

[Caleb]

Something like this? This report will pull the last LsPush scan time as well as the LsPush version.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tsysOS.OSname As [OS Name],
  tblAssets.Description As [AD Description],
  tblAssets.LastLsPush As [Last LsPush Scan],
  tblAssets.LsPushVersion As [LsPush Version],
  tsysOS.Image As icon
From tblComputersystem
  Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblComputersystem.Domainrole > 1 And tblAssetCustom.State = 1
Order By tblAssets.AssetName