Notification

Icon
Error

Failed Deployment Report Issues - Duplicate assets appearing in report

Posted: Monday, May 13, 2019 8:22:22 PM(UTC)
MHScripts

MHScripts

Member Original PosterPosts: 11
0
Like
This issue has been solved! Click here to view the solution
I am trying to make a report that will show the last 100 failed deployments.
The issue is when I run this it just has the same asset listed 100 times.
Wondering what this issue is?
Sorry in advance as I'm sure its something simple I am over looking.




Select Top 100 web50repwindeploymentlogs.AssetID,
web50repwindeploymentlogs.AssetName,
web50repwindeploymentlogs.Domain,
web50repwindeploymentlogs.IPLocation,
web50repwindeploymentlogs.ScanningServer,
web50repwindeploymentlogs.Package,
web50repwindeploymentlogs.LogDate
From tblAssetCustom,
web50repwindeploymentlogs
Where web50repwindeploymentlogs.DeploySuccess = 'No' And tblAssetCustom.State =
1
endyk
#1endyk Member Posts: 24  
posted: 5/14/2019 12:24:25 PM(UTC)
I searched the forum for similar scripts and found the script below. Let me know if it helps.

Select Top 1000000 pl.Added As [Log Date],
pl.ServerName,
a.AssetName,
a.AssetID,
p.PackageName As Package,
p.PackageID,
pl.Executor As Executor,
pl.Errorcode As [Return],
pl.LastStepID As [Last Step],
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 pl.ServerName = ''
Order By [Log Date] Desc

Active Discussions

Lansweeper Windows 7 EOL
by  Esben.D   Go to last post Go to first unread
Last post: Today at 12:22:43 PM(UTC)
Lansweeper Patch Tuesday report, last 3 months
by  Esben.D  
Go to last post Go to first unread
Last post: Today at 10:55:07 AM(UTC)
Lansweeper Thunderbird 68 Vulnerability
by  Esben.D   Go to last post Go to first unread
Last post: Today at 8:41:29 AM(UTC)
Lansweeper Drive Encryption statuses
by  JacobH  
Go to last post Go to first unread
Last post: Yesterday at 5:41:10 PM(UTC)
Report Center Local admin group report based on domain role
by  JacobH   Go to last post Go to first unread
Last post: Yesterday at 5:24:13 PM(UTC)
Lansweeper Number of scanned IPs
by  wayneRex  
Go to last post Go to first unread
Last post: Yesterday at 10:21:01 AM(UTC)
Lansweeper Ticket Summary by Agent?
by  susan.starr   Go to last post Go to first unread
Last post: 9/17/2019 4:41:26 PM(UTC)
Report Center Virtual machines and their host
by  klaus  
Go to last post Go to first unread
Last post: 9/17/2019 8:44:57 AM(UTC)