cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Cieran
Engaged Sweeper II
Hi

Im using the Web Console access report bellow

How can i change it so that it will only show each users first login on every day, instead of showing me logging in 3 times on one day

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

Thanks
0 REPLIES 0