System: Error log (Built-in)

[Daniel_B]

The report below lists all Lansweeper scanning errors with details

Select Top 1000 tsyserrors.Added As AddedDate,
  tsyserrortype.Errorname As Type,
  tsyserrors.Errormsg As Error,
  tsyserrors.Scanserver As ScanServer,
  Case tsyserrors.Errortype When 5 Then 'evinformationsm.png'
    Else 'everrorsm.png' End As icon,
  tsysASServers.Version,
  tsysASServers.Servicestarted As ServiceStarted,
  tsysASServers.Servicelastpolled As ServiceLastPolled
From tsysASServers
  Inner Join (tsyserrors
  Inner Join tsyserrortype On tsyserrors.Errortype = tsyserrortype.ErrorType)
    On tsysASServers.Servername = tsyserrors.Scanserver
Order By tsyserrors.Errorid Desc