
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-03-2009 08:36 PM
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
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
Labels:
- Labels:
-
Report Center
5 REPLIES 5

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-09-2009 07:14 PM
The report depends on some other reports (like web30memory,...)
The problem is most likely in these reports
The problem is most likely in these reports

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-09-2009 05:30 PM
Out of curiosity, I attempted the same SQL code and also received no data. I even removed the WHERE statement.
Any ideas?
Any ideas?

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-04-2009 11:32 PM
Do you need this filter?
Where (web30ProcessorCapacity.[total Proc Capacity] < 1024) Or
(web30memory.Memory < 1024)
Where (web30ProcessorCapacity.[total Proc Capacity] < 1024) Or
(web30memory.Memory < 1024)

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-04-2009 05:36 PM
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 😞
Thanks for your help
ps when i put your query in report builder it didnt not display any data at all 😞

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-04-2009 12:01 PM
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
