
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-08-2011 07:02 PM
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
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
Labels:
- Labels:
-
Archive
5 REPLIES 5

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-10-2011 05:24 PM
ok; done and you now have a Mail from me.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-10-2011 06:22 PM
270admin wrote:
ok; done and you now have a Mail from me.
See reply sent this morning.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-09-2011 06:45 PM
Can you please e-mail us the sql queries and full screenshots of the page. (support@lansweeper.com)

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-09-2011 05:34 PM
Hello,
no; all are Active.
no; all are Active.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-08-2011 08:00 PM
Is it possible that these computers are not marked as "active"
