cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
rallen
Engaged Sweeper II
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.

1 ACCEPTED SOLUTION
FOVISI
Engaged Sweeper
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

View solution in original post

4 REPLIES 4
Susan_A
Lansweeper Alumni
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
rallen
Engaged Sweeper II
Susan.A wrote:
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!
rallen
Engaged Sweeper II
Thank you so very much for your quick reply!!!
FOVISI
Engaged Sweeper
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