Computers not displayed in Reports but he into the Database

[270admin]

Hello,

mysterious but following Situation:

i created a report to view all Serialnumbers from Toshiba-Computers. It runs good but any Computers missed intothe Results. But i can find this Computers into the Report "Computer Model-Overview".

Sample: in my Report i found only one Machine from Typ "S10"; into Modeloverview i found 2 Machines.

Any Idea what#s to check??

Many Thanks!

Here my SQL-Script for the Report:


Select Top 1000000 tblComputerSystemProduct.Vendor, tblComputers.ComputerUnique, tblComputerSystemProduct.Name As Model, tblComputerSystemProduct.IdentifyingNumber As [Identifying Number], Web40OSName.Compimage As icon, tblComputerSystemProduct.Version From tblCompCustom Inner Join tblComputers On tblCompCustom.Computername = tblComputers.Computername Inner Join tblComputerSystemProduct On tblComputers.Computername = tblComputerSystemProduct.Computername Inner Join web40ActiveComputers On web40ActiveComputers.Computername = tblComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Where tblCompCustom.PurchaseDate Is Not Null Or tblCompCustom.Warrantydate Is Not Null Order By tblComputerSystemProduct.Vendor, tblCompCustom.Warrantydate Desc

[270admin]

ok; done and you now have a Mail from me.

[Hemoco]

270admin wrote:
ok; done and you now have a Mail from me.

See reply sent this morning.

[Hemoco]

Can you please e-mail us the sql queries and full screenshots of the page. (support@lansweeper.com)

[270admin]

Hello,

no; all are Active.

[Hemoco]

Is it possible that these computers are not marked as "active"