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: 3
0
Like
This issue has been solved! Click here to view the solution
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: 3  
posted: 5/15/2019 8:16:41 PM(UTC)
Thank you so very much for your quick reply!!! Applause
Susan.A
#3Susan.A Member Administration Posts: 1,535  
posted: 6/3/2019 7:45:13 AM(UTC)
Just as reference for everyone: you can find all built-in Lansweeper reports on the forum.

https://www.lansweeper.com/forum/yaf_topics47_Built-in-Reports.aspx
Melodymaker145
#4Melodymaker145 Member Original PosterPosts: 3  
posted: 6/4/2019 5:23:19 PM(UTC)
Originally Posted by: Susan.A Go to Quoted Post
Just as reference for everyone: you can find all built-in Lansweeper reports on the forum.

https://www.lansweeper.com/forum/yaf_topics47_Built-in-Reports.aspx


I really appreciate this. I have added it to my favorites!

Active Discussions

Lansweeper Report for SSAS and SSIS
by  The Boss   Go to last post Go to first unread
Last post: Yesterday at 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: Yesterday at 3:34:44 PM(UTC)
Lansweeper PO Box Query
by  kmoc   Go to last post Go to first unread
Last post: Yesterday at 11:16:28 AM(UTC)
Lansweeper Computer Age Chart Report
by  CyberCitizen  
Go to last post Go to first unread
Last post: Yesterday at 8:40:47 AM(UTC)
Lansweeper User association report query
by  dan508   Go to last post Go to first unread
Last post: 6/24/2019 5:38:51 PM(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)
Lansweeper Office 365 OneDrive Usage and Sync
by  brodiemac   Go to last post Go to first unread
Last post: 6/21/2019 3:51:36 PM(UTC)
Lansweeper BlueKeep Vulnerability
by  Esben.D  
Go to last post Go to first unread
Last post: 6/21/2019 9:52:22 AM(UTC)