Show all software for all devices by location

[Kreg]

Hello all,
I'm trying to make a query for showing all my asset with all softwares installed with IP location in column.

In my test, I do not show all my computer and I have a lot of duplicate...
Here is my query : Something is wornd ?

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Username,
  tblNetwork.IPAddress,
  tsysIPLocations.IPLocation,
  upgrade_tblSoftware.softwareName,
  upgrade_tblSoftware.softwareVersion
From tblAssets
  Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
    tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join upgrade_tblSoftware On upgrade_tblSoftware.SoftwareID =
    tblSoftware.SoftwareID

Thanks
Kreg

NB : I'm with LanSweeper 5

[Hemoco · Accepted solution]

Most likely you are running out of memory. You will need to split the report into several smaller reports.

[Kreg]

Hi there,

I've updated my query. Now it works, but off course showing a lot of result (> 200 000)
No problem, I like Excel 😉
But I can't export the result ! I got an error every time...
CSV, XLS, same way.

The error is : Web page not found
Error 6 (net::ERR_FILE_NOT_FOUND) : the file or directory could not be found

Tested with Chrome 24 and IE9.
My Lansweeper version : 5.0.0.41

The query is :

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssets.Lastseen,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblADusers.Firstname,
  tblADusers.Lastname,
  tblSoftwareUni.softwareName,
  tblSoftware.softwareVersion,
  tblSoftwareUni.SoftwarePublisher,
  tblSoftware.Lastchanged,
  tblOperatingsystem.Caption
From tblAssets
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
    tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
  Left Join tblADusers On tblADusers.Username = tblAssets.Username And
    tblADusers.Userdomain = tblAssets.Userdomain
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
  Inner Join tblOperatingsystem
    On tblAssets.AssetID = tblOperatingsystem.AssetID
Order By tsysIPLocations.IPLocation,
  tblAssets.AssetName,
  tblSoftwareUni.softwareName,
  tblSoftware.softwareVersion

An idea ?
Tks,
Kreg