Minimum Standard Hardware Report

[bubblie]

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

[Hemoco]

The report depends on some other reports (like web30memory,...)
The problem is most likely in these reports

[scpspjk]

Out of curiosity, I attempted the same SQL code and also received no data. I even removed the WHERE statement.
Any ideas?

[Hemoco]

Do you need this filter?

Where (web30ProcessorCapacity.[total Proc Capacity] < 1024) Or
(web30memory.Memory < 1024)

[bubblie]

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 😞

[Hemoco]

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 =
    tblComputers.Computername
Where (web30ProcessorCapacity.[total Proc Capacity] < 1024) Or
  (web30memory.Memory < 1024)
Order By tblComputers.Computername