Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper III
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

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


Engaged Sweeper III
Thanks that worked. Always great support.
Lansweeper Alumni
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
Order By tblSoftware.softwareName, tblComputers.Computer