cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Kreg
Engaged Sweeper II
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Most likely you are running out of memory. You will need to split the report into several smaller reports.

View solution in original post

2 REPLIES 2
Hemoco
Lansweeper Alumni
Most likely you are running out of memory. You will need to split the report into several smaller reports.
Kreg
Engaged Sweeper II
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