→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
mbourgeois
Engaged Sweeper
I have created a report for reviewing the monitors attached to a computer. The report shows different manufacturer data on the report than what I see in the computer summary view. Where can I find the data shown on the summary view.
Here is my report, a screenshot of report result and screen summary is attached
Select Top 1000000 tblAssetCustom.Branchoffice,
Computer.AssetName,
tblADComputers.Description,
tblMonitor.MonitorModel,
tblMonitor.MonitorManufacturer,
tblMonitor.SerialNumber,
tblMonitor.ManufacturedDate,
tblAssetCustom.PurchaseDate,
tblADusers.Displayname,
tblADusers.Department,
tblMonitor.MonitorID As MonitorID1,
Computer.AssetID
From tblAssets Computer
Left Join tblOperatingsystem On Computer.AssetID = tblOperatingsystem.AssetID
Inner Join tblAssetCustom On Computer.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On Computer.OScode = tsysOS.OScode
Left Join tblADusers On Computer.Username = tblADusers.Username
Left Join tblADComputers On Computer.AssetID = tblADComputers.AssetID And
Computer.AssetID = tblADComputers.AssetID
Left Join tblMonitor On Computer.AssetID = tblMonitor.AssetID
Where tsysOS.OScode Not Like '%s'
Order By tblAssetCustom.Branchoffice,
tblAssetCustom.PurchaseDate Desc,
Computer.AssetName
0 REPLIES 0