Multiple results per device

[imaginethat]

Hi all
I am trying to create a report that gives me a few different things, IP, MAC, MachineName, Monitor Serial Number etc.
I have been able to run the existing reports fine, but if I add anything to these reports, or create reports of my own, I get all the data, but there are 10 results for each device.
What am I doing wrong?
Here is an example of a report i have created, and each device gives me 10 results, and the MAC seems to be different on 5 of those results, so a bit odd.
--------------------------------------------------------------------
Select Top 1000000 dbo.tblBIOS.SerialNumber, dbo.tblComputers.Computer
As Hostname, dbo.tblComputers.LastknownIP, dbo.tblNetwork.MACaddress
From dbo.tblComputers Inner Join
dbo.tblBIOS On dbo.tblComputers.Computername = dbo.tblBIOS.Computername
Inner Join
tblSystemEnclosure On dbo.tblComputers.Computername =
tblSystemEnclosure.Computername
Inner Join
tblComputerSystemProduct On dbo.tblComputers.Computername =
tblComputerSystemProduct.Computername
Inner Join
tblNetwork On dbo.tblComputers.Computername = tblNetwork.Computername
---------------------------------------------------------------------

What is the difference between dbo.tblBlablabla.Bla and just tblBlablabla.Bla.
Also I am not sure what the difference is between the "tbl" and the "web40rep" are on the right hand column of the lansweeper config window.
Is the infinite symbol linking the tables important?

Look forward to hearing from you.

cheers

imaginethat

[bungargp]

Somehow I missed that response...and it worked!! Thanks again!

[i_kulgu]

I don't think.. did you tried what lansweeper said ?

You can filter out chassistype=12 which is a docking station.

[bungargp]

Thanks...still getting the double entries for some of my laptops. I wonder if it has anything to do with those laptops being on docking stations?

[i_kulgu]

Try this

Select Distinct Top 1000000 dbo.tblComputers.Computer As [Computer Name],
  dbo.tblComputersystem.Manufacturer, dbo.tblComputersystem.Model,
  Cast(dbo.web30ProcessorCapacity.NrOfProcessors As VarChar) + ' * ' +
  Cast(dbo.web30ProcessorCapacity.MaxClockSpeed As VarChar) + ' Mhz' As
  Processor, Cast(Cast(Cast(dbo.tblComputersystem.TotalPhysicalMemory As BigInt)
  / 1024 / 1024 As Numeric) As VarChar) + ' KB' As Memory,
  Cast(Cast(Cast(dbo.tblDiskdrives.Size As BigInt) / 1024 / 1024 /
  1024 As Numeric) As VarChar) + ' GB' As HDDsize, dbo.tblComputers.LastknownIP
  As [IP  Address], dbo.tblComputers.LastActiveScan As [Date Scanned],
  tblComputerSystemProduct.IdentifyingNumber As Serial,
  tblBIOS.SMBIOSBIOSVersion As [BIOS Version],
  tblADComputers.OperatingSystemServicePack As [XP Service Pack],
  tblSystemEnclosure.SMBIOSAssetTag, dbo.tblComputers.Computername
From dbo.tblComputers Inner Join
  dbo.tblComputersystem On dbo.tblComputers.Computername =
    dbo.tblComputersystem.Computername Inner Join
  dbo.tblDiskdrives On dbo.tblComputers.Computername =
    dbo.tblDiskdrives.Computername Left Outer Join
  dbo.web30ProcessorCapacity On dbo.tblComputers.Computername =
    dbo.web30ProcessorCapacity.Computername Inner Join
  tblComputerSystemProduct On dbo.tblComputers.Computername =
    tblComputerSystemProduct.Computername Inner Join
  tblBIOS On dbo.tblComputers.Computername = tblBIOS.Computername Inner Join
  tblADComputers On tblADComputers.Computername = dbo.tblComputers.Computername
  Inner Join
  tblSystemEnclosure On dbo.tblComputers.Computername =
    tblSystemEnclosure.Computername
Where dbo.tblComputersystem.Domainrole = '1' And dbo.tblDiskdrives.Caption =
  'c:'
Order By dbo.tblComputers.Computer, dbo.tblComputers.Computername

[Hemoco]

You can filter out chassistype=12 which is a docking station.

[bungargp]

I am not sure what you mean by this...can you give me a little more detail...thanks for your reply!

[i_kulgu]

Try ; Select distinct

[bungargp]

Any answers to my problem above?

[bungargp]

I think my problem may be that some of my laptops are on a docking station. It appears that they are showing up twice in my report below. Is there a way to only have them appear once...say to the wired nic?

Select Top 1000000 dbo.tblComputers.Computer As [Computer Name],
  dbo.tblComputersystem.Manufacturer, dbo.tblComputersystem.Model,
  Cast(dbo.web30ProcessorCapacity.NrOfProcessors As VarChar) + ' * ' +
  Cast(dbo.web30ProcessorCapacity.MaxClockSpeed As VarChar) + ' Mhz' As
  Processor, Cast(Cast(Cast(dbo.tblComputersystem.TotalPhysicalMemory As BigInt)
  / 1024 / 1024 As Numeric) As VarChar) + ' KB' As Memory,
  Cast(Cast(Cast(dbo.tblDiskdrives.Size As BigInt) / 1024 / 1024 /
  1024 As Numeric) As VarChar) + ' GB' As HDDsize, dbo.tblComputers.LastknownIP
  As [IP  Address], dbo.tblComputers.LastActiveScan As [Date Scanned],
  tblComputerSystemProduct.IdentifyingNumber As Serial,
  tblBIOS.SMBIOSBIOSVersion As [BIOS Version],
  tblADComputers.OperatingSystemServicePack As [XP Service Pack],
  tblSystemEnclosure.SMBIOSAssetTag
From dbo.tblComputers Inner Join
  dbo.tblComputersystem On dbo.tblComputers.Computername =
    dbo.tblComputersystem.Computername Inner Join
  dbo.tblDiskdrives On dbo.tblComputers.Computername =
    dbo.tblDiskdrives.Computername Left Outer Join
  dbo.web30ProcessorCapacity On dbo.tblComputers.Computername =
    dbo.web30ProcessorCapacity.Computername Inner Join
  tblComputerSystemProduct On dbo.tblComputers.Computername =
    tblComputerSystemProduct.Computername Inner Join
  tblBIOS On dbo.tblComputers.Computername = tblBIOS.Computername Inner Join
  tblADComputers On tblADComputers.Computername = dbo.tblComputers.Computername
  Inner Join
  tblSystemEnclosure On dbo.tblComputers.Computername =
    tblSystemEnclosure.Computername
Where dbo.tblComputersystem.Domainrole = '1' And dbo.tblDiskdrives.Caption =
  'c:'
Order By dbo.tblComputers.Computername