Duplicate Assets for Installed Software Report

[malbanese1]

I have the following report that gives me the versions of Internet Explorer that are installed on machines in our network. I am getting duplicate entries for each computer but I'm not quite sure why. I don't think that there are multiple versions installed on the PC.

Any help would be appreciated.

Select Top 1000000 tblAssets.IPAddress As IP,
tsysIPLocations.IPLocation,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Username,
tblFileVersions.FileVersion,
tblFileVersions.FilePathfull,
tblAssets.LastActiveScan
From tblAssets
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID
Where tblAssets.IPAddress <> '' And tblFileVersions.FilePathfull Like
'%iexplore.exe'
Order By tblAssets.IPNumeric

[Daniel_B · Accepted solution]

As your report only contains the tables tblAssets, tsysIPlocations and tblFileVersions, duplicates are either caused by multiple versions of iexplore.exe on the same machine (i.e. one 32-bit and one 64-bit version) or by overlapping IP ranges under Configuration\Asset groups, section IP Address Range locations.