Notification

Icon
Error

Monitor: information original report needed - I need original please

Posted: Wednesday, May 15, 2019 7:40:39 PM(UTC)
Melodymaker145

Melodymaker145

Member Original PosterPosts: 2
0
Like
I thought I was saving as a new test report, but I accidentally wrote over the original Lansweeper "Monitor: information" report. Could someone please respond with a copy of that report for me? I would greatly appreciate it.

FOVISI
#1FOVISI Member Posts: 3  
posted: 5/15/2019 7:57:12 PM(UTC)
Here is the original query.
Enjoy !


Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysOS.OSname,
tsysOS.Image As icon,
tblMonitor.MonitorManufacturer As Manufacturer,
tblMonitor.MonitorModel,
tblMonitor.SerialNumber,
tblMonitor.ManufacturedDate
From tblAssets
Inner Join tblMonitor On tblMonitor.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName
Melodymaker145
#2Melodymaker145 Member Original PosterPosts: 2  
posted: 5/15/2019 8:16:41 PM(UTC)
Thank you so very much for your quick reply!!! Applause

Active Discussions

Lansweeper Update DNS record
by  Lewis_Spokane   Go to last post Go to first unread
Last post: Today at 12:17:26 AM(UTC)
Lansweeper Trigger deploy when seen
by  bbazian  
Go to last post Go to first unread
Last post: Yesterday at 9:13:02 PM(UTC)
Lansweeper Restoring server from backup, retaining Lansweeper
by  JacobH   Go to last post Go to first unread
Last post: Yesterday at 8:48:39 PM(UTC)
Lansweeper LSAgent has forgotten x64 Windows applications
by  Esben.D  
Go to last post Go to first unread
Last post: Yesterday at 3:37:55 PM(UTC)
Lansweeper Not finding some switches on IP range scan
by  acstanley   Go to last post Go to first unread
Last post: Yesterday at 1:23:36 PM(UTC)
Report Center BIOS version check
by  Esben.D  
Go to last post Go to first unread
Last post: Yesterday at 1:22:28 PM(UTC)
Lansweeper Generate report based upon filter?
by  pryan67   Go to last post Go to first unread
Last post: Yesterday at 1:20:58 PM(UTC)
Lansweeper report in defined period
by  CHIREC  
Go to last post Go to first unread
Last post: Yesterday at 10:46:34 AM(UTC)