Memory Name

[kevinoie]

Hi. I would be grateful if you could assist... Im trying to add Memory Name to this report.

Select Top 1000000 tblComputers.Computer, tblADusers.Displayname,
tblComputerSystemProduct.Vendor As Manufacturer, tblComputerSystemProduct.Name
As Model, TsysChassisTypes.ChassisName, tblOperatingsystem.Caption,
Web40OSName.SP, web40ProcessorCapacity.CPU,
web40ProcessorCapacity.NrOfProcessors, web40CorrectMemory.Memory,
tblComputers.LastknownIP, tblADusers.Department, tblADusers.Office
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 Inner Join
tblSystemEnclosure On tblSystemEnclosure.Computername =
tblComputers.Computername Inner Join
TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes Left Join
tblADusers On tblADusers.Username = tblComputers.Username And
tblADusers.Userdomain = tblComputers.Userdomain
Order By tblOperatingsystem.Caption


However, When I add the memory name field from tsysMemoryTypes I get about 6 different records for each pc and I know most of these devices only have either a single 2GB or 4GB stick of RAM.

any help would be grately appreciated..

[Hemoco]

You haven't included tblPhysicalMemory in your report, which is the table tsysMemoryTypes needs to be linked to. Also note that tsysMemoryTypes.MemoryName stores the name of the type of memory that's installed: Flash, DDR...

Please try the report below instead.

Select Top 1000000 Web40OSName.Compimage As icon, tblComputers.Computername, tblComputers.Computer, tblComputers.Domain, tblComputers.LastknownIP, tblADusers.Displayname, tblADusers.Department, tblADusers.Office, tblComputerSystemProduct.Vendor As Manufacturer, tblComputerSystemProduct.Name As Model, TsysChassisTypes.ChassisName, tblOperatingsystem.Caption, Web40OSName.SP, web40ProcessorCapacity.CPU, web40ProcessorCapacity.NrOfProcessors, web40CorrectMemory.Memory As TotalMemory, tblPhysicalMemory.Tag, tblPhysicalMemory.DeviceLocator, Ceiling(tblPhysicalMemory.Capacity / 1024 / 1024) As Capacity, tblPhysicalMemory.PositionInRow, tblPhysicalMemory.DataWidth, tblPhysicalMemory.BankLabel, tblPhysicalMemory.FormFactor, tblPhysicalMemory.InterleaveDataDepth, tblPhysicalMemory.InterleavePosition, TsysMemorytypes.MemoryName, tblPhysicalMemory.Speed, tblPhysicalMemory.TotalWidth, tblPhysicalMemory.TypeDetail, tblPhysicalMemory.Lastchanged From tblComputers Inner Join web40CorrectMemory On web40CorrectMemory.Computername = tblComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join tblComputerSystemProduct On tblComputers.Computername = tblComputerSystemProduct.Computername Inner Join tblOperatingsystem On tblComputers.Computername = tblOperatingsystem.Computername Inner Join web40ProcessorCapacity On web40ProcessorCapacity.Computername = tblComputers.Computername Left Join tblSystemEnclosure On tblSystemEnclosure.Computername = tblComputers.Computername Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype = tblSystemEnclosure.ChassisTypes Left Join tblADusers On tblADusers.Username = tblComputers.Username And tblADusers.Userdomain = tblComputers.Userdomain Inner Join tblPhysicalMemory On tblComputers.Computername = tblPhysicalMemory.Computername Inner Join TsysMemorytypes On TsysMemorytypes.Memorytype = tblPhysicalMemory.MemoryType Order By tblOperatingsystem.Caption, tblComputers.Domain, tblComputers.Computer, tblPhysicalMemory.Tag