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

Action Change Windows domain PC Name
by  max204   Go to last post Go to first unread
Last post: 9/19/2019 10:28:29 AM(UTC)
Lansweeper Launch PowerShell remote PSSession
by  Ian  
Go to last post Go to first unread
Last post: 9/9/2019 12:10:56 PM(UTC)
Action Remote print management
by  CyberCitizen   Go to last post Go to first unread
Last post: 9/4/2019 3:53:00 AM(UTC)
Lansweeper Infopath installer help
by  CyberCitizen  
Go to last post Go to first unread
Last post: 9/2/2019 8:18:06 AM(UTC)
Lansweeper Remote Registry 2019
by  EB   Go to last post Go to first unread
Last post: 8/22/2019 3:47:10 PM(UTC)
Lansweeper lspush smtp direct send
by  Danilo Ferrari  
Go to last post Go to first unread
Last post: 8/1/2019 1:39:26 PM(UTC)
Action Delete old user profiles
by  DaveDischord   Go to last post Go to first unread
Last post: 7/30/2019 6:18:28 PM(UTC)
Lansweeper Best way to delete multiple registries
by  Corcos  
Go to last post Go to first unread
Last post: 7/25/2019 8:18:23 PM(UTC)