ReportBuilder - Desktop Model / info needed

[neosys]

Hello,
I am tring to build a new report to see the screen manufacturer for each PC - to link with asset tags...
On the web interface I sometimes only see one desktop screen whereas there should be 2 connected.

Any Idea why they would not show up ?

thanks,
Neosys

[Hemoco]

Do a select only on tbldesktopmonitor, then you can see how many entries there are for each computer.

[neosys]

I believe my SQL query is not correct but I am new to this.

[Hemoco]

So it's a scanning problem?

[neosys]

In the report I cannot as of now report what I need.
using the web interface I can see 2 screens attached to a PC but for another one I can only see one.

This is what I figured I needed in the report builder:

SELECT 
  dbo.tblComputers.Computername AS Computer,
  dbo.tblOperatingsystem.Description,
  dbo.tblComputersystem.Manufacturer,
  dbo.tblComputersystem.Model,
  tblDesktopMonitor.MonitorManufacturer,
  tblDesktopMonitor.DeviceID,
  tblDesktopMonitor.ScreenWidth,
  tblDesktopMonitor.ScreenHeight,
  tblDesktopMonitor.Computername
FROM
  dbo.tblComputers
  INNER JOIN dbo.tblComputersystem ON (dbo.tblComputers.Computername = dbo.tblComputersystem.Computername)
  INNER JOIN dbo.tblOperatingsystem ON (dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername)
  INNER JOIN tblDesktopMonitor ON (dbo.tblComputers.Computername = tblDesktopMonitor.MonitorManufacturer)

But I am missing parts in order to get results out of it.

[Hemoco]

Is the problem that your report is showing incorrect information or that lansweeper is not scanning all data?

Please post any screenshots,... that you can provide.