![sullivane sullivane](https://community.lansweeper.com/legacyfs/online/forums_avatars/10024.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-01-2015 03:44 PM
Can you make a report that returns info from the deployment log?
Solved! Go to Solution.
- Labels:
-
Report Center
![Daniel_B Daniel_B](https://community.lansweeper.com/legacyfs/online/forums_avatars/9715.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-02-2015 02:09 PM
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 pl.ServerName = 'asd-util-02 '
Order By [Log Date] Desc
![sullivane sullivane](https://community.lansweeper.com/legacyfs/online/forums_avatars/10024.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-02-2015 08:14 PM
![Daniel_B Daniel_B](https://community.lansweeper.com/legacyfs/online/forums_avatars/9715.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-02-2015 07:37 PM
and pl.Added >= Cast(DateDiff(d,0,GetDate()) as DateTime)
It looks a bit complicated, but in this way it is compatible to SQL Compact.
![sullivane sullivane](https://community.lansweeper.com/legacyfs/online/forums_avatars/10024.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-02-2015 02:58 PM
Thanks for all your help on this!!
![sullivane sullivane](https://community.lansweeper.com/legacyfs/online/forums_avatars/10024.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-02-2015 02:15 PM
Thanks!!
![Daniel_B Daniel_B](https://community.lansweeper.com/legacyfs/online/forums_avatars/9715.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-02-2015 02:09 PM
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 pl.ServerName = 'asd-util-02 '
Order By [Log Date] Desc
![sullivane sullivane](https://community.lansweeper.com/legacyfs/online/forums_avatars/10024.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-01-2015 07:31 PM
![esr esr](https://community.lansweeper.com/html/assets/User_Avatar.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-01-2015 05:33 PM
The tables are tsysPackageLogs and tsysPackages
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 pl.ServerName = @Servername
Order By [Log Date] Desc
![](/skins/images/6AE91C23811BC8C2ED7451073DC36BEF/responsive_peak/images/icon_anonymous_message.png)