→ Upcoming Keynote Event - Introducing Lansweeper's 2023 Spring Release: 'Duvel' - Learn More
‎08-08-2017 04:19 PM
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
‎03-08-2022 03:27 PM
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
Test Drive Lansweeper Yourself. Explore our interactive Demo or sign up for free 14-day trial.
Try Now