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: 10
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: 23  
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 Firefox 67.0.3 zero-day vulnerability
by  B Claeys   Go to last post Go to first unread
Last post: Today at 3:13:30 PM(UTC)
Lansweeper BlueKeep Vulnerability
by  heybobby1  
Go to last post Go to first unread
Last post: Today at 3:02:34 PM(UTC)
Lansweeper VLC Player CVE-2019-5439
by  Esben.D   Go to last post Go to first unread
Last post: Yesterday at 9:19:29 AM(UTC)
Lansweeper Enabled/Disabled Local/AD Admin accounts
by  vqT4cDoP9iXyMZwoDUWU  
Go to last post Go to first unread
Last post: 6/17/2019 9:12:30 PM(UTC)
Lansweeper code in posts
by  AZHockeyNut   Go to last post Go to first unread
Last post: 6/14/2019 4:39:46 PM(UTC)
Lansweeper Adding more info to asset report
by  RC62N   Go to last post Go to first unread
Last post: 6/13/2019 9:46:31 PM(UTC)
Report Center Top 5 Average RAM Usage
by  Esben.D  
Go to last post Go to first unread
Last post: 6/13/2019 1:15:31 PM(UTC)