Users: Logins into the Lansweeper web console (Built-in)

[Nick_VDB]

Added in v.6.0.100

The report below lists the logins that were made to the Lansweeper webconsole and whether they were successful or not.

Select Top 1000000 tblLoginLog.Date As LoginDate,
  Case tblLoginLog.Success When 1 Then 'yes' When 0 Then 'no'
  End As LoginSuccessful,
  tblLoginLog.UserName As Username,
  tblLoginLog.IPAddress,
  tblLoginLog.cert As Certificate,
  Case tblLoginLog.Success When 1 Then 'green' When 0 Then 'red'
  End As foregroundcolor,
  Case tblLoginLog.Success When 1 Then '#dfffdb' When 0 Then '#fbfb86'
  End As backgroundcolor
From tblLoginLog
Order By LoginDate Desc

[jseet]

Nick.VDB wrote:
Added in v.6.0.100

The report below lists the logins that were made to the Lansweeper webconsole and whether they were successful or not.

Select Top 1000000 tblLoginLog.Date As LoginDate,
  Case tblLoginLog.Success When 1 Then 'yes' When 0 Then 'no'
  End As LoginSuccessful,
  tblLoginLog.UserName As Username,
  tblLoginLog.IPAddress,
  tblLoginLog.cert As Certificate,
  Case tblLoginLog.Success When 1 Then 'green' When 0 Then 'red'
  End As foregroundcolor,
  Case tblLoginLog.Success When 1 Then '#dfffdb' When 0 Then '#fbfb86'
  End As backgroundcolor
From tblLoginLog
Order By LoginDate Desc

This report appears to be broken in the new version of lansweeper. Currently running v9.1.20.2 and the report only shows activity from 3 months ago.