Report builder issues

[seth921]

I recently updated to Lansweeper 5.1 from 5.0, but have been experiencing this issue in 5.0 as well.

When I open my report builder (Reports -> Create New Report) and enter any SQL query in the field, I can never get the Builder to update)

I've attached a screenshot of the builder screen after I have set up my query and clicked in the above area of the builder to update the page. The query entered is:

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblFileVersions.Found,
tblFileVersions.FilePathfull,
tblFileVersions.FileVersion,
tblFileVersions.CompanyName,
tblFileVersions.Filesize,
tblFileVersions.CreationDate,
tblFileVersions.LastAccessed,
tblFileVersions.LastModified,
tblFileVersions.Lastchanged
From tblAssets
Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblFileVersions.FilePathfull Like '%iexplore.exe' And
tblAssetCustom.State = 1
Order By tblAssets.AssetUnique,
tblFileVersions.FilePathfull


Is there anything that I am missing as far as building this report goes? Or could there be something wrong with my configuration? Thanks,

[seth921]

The application pool was, indeed, the issue. I changed to the proper app pool and everything works properly now. Thank you 🙂

[Hemoco · Accepted solution]

If you are using IIS, make sure that the application pool is set correctly: http://www.lansweeper.com/kb/48/Lansweeper-5.0-does-not-work-on-manually-installed-IIS-sites..html