Duplicate software entries when creating Custom Report

[Ingraham2]

I am trying to create a report on all Microsoft products installed. The report is below. I have limited it to one PC for testing. When I run this the results show a duplicate of every software. If i look at the software from the webconsole for this PC it shows each software only once. This is happening to many PC's.

I am running version 4.2.0.4


Select Top 1000000 dbo.tblComputers.Computer, dbo.tblComputers.Username,
dbo.tblSoftware.softwareName, dbo.tblSoftware.softwareVersion
From dbo.tblComputers Inner Join
dbo.tblSoftware On (dbo.tblComputers.Computername =
dbo.tblSoftware.ComputerName) Inner Join
tblADusers On tblADusers.Username = dbo.tblComputers.Username
Where dbo.tblComputers.Computer = 'spw5690' And dbo.tblSoftware.softwareName
Like 'Microsoft%'
Order By dbo.tblSoftware.softwareName, dbo.tblComputers.Computer

Thanks

[Ingraham2]

Thanks that worked. Always great support.

[Hemoco]

TblADusers is not correctly linked to tblComputers. These tables must be linked on both the Username and Userdomain fields.

Please try the report below instead.

Select Top 1000000 tblComputers.Computer, tblComputers.Username,
tblSoftware.softwareName, tblSoftware.softwareVersion
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Inner Join
tblADusers On tblADusers.Username = tblComputers.Username And
tblADusers.Userdomain = tblComputers.Userdomain
Where tblComputers.Computer = 'spw5690' And tblSoftware.softwareName Like
'Microsoft%'
Order By tblSoftware.softwareName, tblComputers.Computer