Deployment report with only newest entries

[MikW]

Hi,

I found a deployment report and was able to partially modify it to my needs but not quite there yet. I'm not good in SQL.

I deploy a package and need to redeploy on assets where it failed for some reason.
When running deployment for the second time new line gets created for the same asset and I would like to filter the old line out to have current result.
Idea is to end up with smaller and smaller report each time a successful deployment occurs.

Can you help me? Thanks.

Select Top 1000000 pl.Added As [Log Date],
  a.AssetName,
  a.AssetID,
  p.PackageName As Package,
  p.PackageID,
  pl.Executor As Executor,
  pl.Errorcode As [Return],
  pl.LastStepID As [Last Step],
  Case When pl.RunMode = 1 Then 'System Account'
    When pl.RunMode = 2 Then 'Scanning Credentials'
    When pl.RunMode = 3 Then 'Currently Logged On' End As [Run Mode],
  Case When pl.Success = 1 Then 'black' Else 'red' End As foregroundcolor,
  Case When pl.Success = 1 Then 'tick.png' Else 'minus.png' End As icon,
  pl.Errormessage As Message,
  pl.Version As [Deployer Version]
From tsysPackageLogs pl
  Left Outer Join tblAssets a On pl.AssetID = a.AssetID
  Join tsysPackages p On pl.PackageID = p.PackageID
Where p.PackageName = 'Some_package' And
  pl.Errormessage Not Like '%Stop(Success)%' And pl.ServerName =
  'some_server'
Order By [Log Date] Desc