→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
malbanese1
Engaged Sweeper II
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
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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.

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
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.