→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
270admin
Engaged Sweeper
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
5 REPLIES 5
270admin
Engaged Sweeper
ok; done and you now have a Mail from me.
Hemoco
Lansweeper Alumni
270admin wrote:
ok; done and you now have a Mail from me.

See reply sent this morning.
Hemoco
Lansweeper Alumni
Can you please e-mail us the sql queries and full screenshots of the page. (support@lansweeper.com)
270admin
Engaged Sweeper
Hello,

no; all are Active.
Hemoco
Lansweeper Alumni
Is it possible that these computers are not marked as "active"