‎07-25-2019 12:26 AM
‎07-31-2019 04:32 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.Lastseen < DateAdd(dd, -3, GetDate()) And tblAssetCustom.State =
1 And tblAssets.OScode Like '%s'
Order By tblAssets.Lastseen
‎07-25-2019 11:09 AM
‎07-25-2019 03:01 PM
Esben.D wrote:
Try removing the Alert Report widget and see if that has any impact.
What is your database (SQL Compact or SQL Server) and web server setup (IIS Express or IIS) like?
Maybe this topic helps: https://www.lansweeper.com/forum/yaf_postst17188_LS-Dashboard-Reports-Broken.aspx
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now