‎04-19-2016 11:00 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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now