
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-02-2011 02:41 PM
Hi all, Would be very grateful for help with the following. Im trying to create an ad-hoc report, using the report builder, with the following headings. Computer, Manafucturer, Model, Chassis, OSName, CPU, num of processors, memory, ipaddress, installdate and username. I can manage to get most of it but i cant find where to add Chassis type... Any help greatly appreciated.
here is what i have already..
Select Top 1000000 tblComputers.Computer, tblComputerSystemProduct.Vendor As Manufacturer, tblComputerSystemProduct.Name As Model, Web40OSName.OSname, Web40OSName.SP, web40ProcessorCapacity.CPU, web40ProcessorCapacity.NrOfProcessors, web40CorrectMemory.Memory, tblComputers.LastknownIP, tblOperatingsystem.InstallDate, tblComputers.Username From tblComputers Inner Join web40CorrectMemory On web40CorrectMemory.Computername = tblComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join tblComputerSystemProduct On tblComputers.Computername = tblComputerSystemProduct.Computername Inner Join tblOperatingsystem On tblComputers.Computername = tblOperatingsystem.Computername Inner Join web40ProcessorCapacity On web40ProcessorCapacity.Computername = tblComputers.Computername Order By tblComputers.Computer
here is what i have already..
Select Top 1000000 tblComputers.Computer, tblComputerSystemProduct.Vendor As Manufacturer, tblComputerSystemProduct.Name As Model, Web40OSName.OSname, Web40OSName.SP, web40ProcessorCapacity.CPU, web40ProcessorCapacity.NrOfProcessors, web40CorrectMemory.Memory, tblComputers.LastknownIP, tblOperatingsystem.InstallDate, tblComputers.Username From tblComputers Inner Join web40CorrectMemory On web40CorrectMemory.Computername = tblComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join tblComputerSystemProduct On tblComputers.Computername = tblComputerSystemProduct.Computername Inner Join tblOperatingsystem On tblComputers.Computername = tblOperatingsystem.Computername Inner Join web40ProcessorCapacity On web40ProcessorCapacity.Computername = tblComputers.Computername Order By tblComputers.Computer
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-02-2011 07:55 PM
You need to link:
tblsystemenclosure to tblcomputers on computername
tsyschassistypes to tblsystemenclosure on Chassistype
tblsystemenclosure to tblcomputers on computername
tsyschassistypes to tblsystemenclosure on Chassistype
3 REPLIES 3

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-02-2011 07:55 PM
You need to link:
tblsystemenclosure to tblcomputers on computername
tsyschassistypes to tblsystemenclosure on Chassistype
tblsystemenclosure to tblcomputers on computername
tsyschassistypes to tblsystemenclosure on Chassistype

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-02-2011 03:32 PM
You need tables:
tblSystemEnclosure
TsysChassisTypes
tblSystemEnclosure
TsysChassisTypes

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-02-2011 04:07 PM
Lansweeper wrote:
You need tables:
tblSystemEnclosure
TsysChassisTypes
Thanks for that. The first table only gives me a numeric value and the second one gives me a lot of instances of the same device. Is there any way i can cut it down?
thanks again
