cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

Nick_VDB
Champion Sweeper III
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
1 REPLY 1

jseet
Engaged Sweeper II
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.