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