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: 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 Clients missing specific Office feature
by  CyberCitizen   Go to last post Go to first unread
Last post: Today at 1:28:26 AM(UTC)
Report Center Windows 10 compliance (color-coded)
by  CyberCitizen  
Go to last post Go to first unread
Last post: Today at 1:15:07 AM(UTC)
Lansweeper User association report query
by  endyk   Go to last post Go to first unread
Last post: Yesterday at 9:47:25 PM(UTC)
Lansweeper Report for SSAS and SSIS
by  The Boss  
Go to last post Go to first unread
Last post: 6/25/2019 6:53:21 PM(UTC)
Lansweeper Firefox 67.0.3 zero-day vulnerability
by  Esben.D   Go to last post Go to first unread
Last post: 6/25/2019 3:34:44 PM(UTC)
Lansweeper PO Box Query
by  kmoc  
Go to last post Go to first unread
Last post: 6/25/2019 11:16:28 AM(UTC)
Lansweeper Computer Age Chart Report
by  CyberCitizen   Go to last post Go to first unread
Last post: 6/25/2019 8:40:47 AM(UTC)
Lansweeper Dell SupportAssist CVE-2019-12280
by  Esben.D  
Go to last post Go to first unread
Last post: 6/24/2019 9:15:20 AM(UTC)