Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper
Good Afternoon,
I am trying to use report builder and am still having some issues with the data not appearing. I can run the query in SQL however when I copy the sql statement to report builder no data appears. You have a minimum standards report however it doesn’t include the asset tag number or serial number. Please see attached

What I need displayed on the report is
1. Computer name
2. Asset Tag and or serial number (identifying number)
3. Description
4. Memory
5. Hard drive total capacity
6. Processor Capacity
7. Model
8 Manufactures
9. Last Seen

Thank you very much
Lansweeper Alumni
The report depends on some other reports (like web30memory,...)
The problem is most likely in these reports
Engaged Sweeper
Out of curiosity, I attempted the same SQL code and also received no data. I even removed the WHERE statement.
Any ideas?
Lansweeper Alumni
Do you need this filter?

Where (web30ProcessorCapacity.[total Proc Capacity] < 1024) Or
(web30memory.Memory < 1024)
Engaged Sweeper
Good Morning I tried running this query and I am pulling back only 2 lines of data which i know is not accurate. I ran the querey that I provided just to see if there were other machines out there that were lacking in any of these area and there were many more.

Thanks for your help

ps when i put your query in report builder it didnt not display any data at all 😞
Lansweeper Alumni
This should work:

Select tblComputers.Computername As Computer,
tblComputerSystemProduct.IdentifyingNumber, tblOperatingsystem.Description,
web30memory.Memory, web30ProcessorCapacity.[total Proc Capacity],
tblComputersystem.Model, tblComputersystem.Manufacturer,
tblComputers.Lastseen, web30repHDDFreeWorkstations.[Total size]
From tblComputers Inner Join
web30ProcessorCapacity On (tblComputers.Computername =
web30ProcessorCapacity.Computername) Inner Join
web30memory On (tblComputers.Computername = web30memory.Computer) Inner Join
tblComputersystem On (tblComputers.Computername =
tblComputersystem.Computername) Inner Join
tblOperatingsystem On (tblComputers.Computername =
tblOperatingsystem.Computername) Left Outer Join
tblComputerSystemProduct On (tblComputers.Computername =
tblComputerSystemProduct.Computername) Inner Join
web30repHDDFreeWorkstations On web30repHDDFreeWorkstations.Computer =
Where (web30ProcessorCapacity.[total Proc Capacity] < 1024) Or
(web30memory.Memory < 1024)
Order By tblComputers.Computername