Notification

Icon
Error

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

Posted: Tuesday, August 8, 2017 3:19:01 PM(UTC)
Nick.VDB

Nick.VDB

Member Lansweeper Developer Administration Original PosterPosts: 251
0
Like
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.
Code:

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

Active Discussions

Lansweeper Modify "....less than 1GB free HD..." Report
by  Cripple.Zero   Go to last post Go to first unread
Last post: 8/15/2019 7:11:10 PM(UTC)
Lansweeper Individual asset compliance
by  ToeCutter  
Go to last post Go to first unread
Last post: 8/15/2019 11:40:57 AM(UTC)
Lansweeper Nvidia August Security Bulletin
by  Esben.D   Go to last post Go to first unread
Last post: 8/14/2019 9:00:17 AM(UTC)
Lansweeper Patch Tuesday report, last 3 months
by  Esben.D  
Go to last post Go to first unread
Last post: 8/14/2019 8:40:45 AM(UTC)
Lansweeper Help Desk report charted by Fiscal Year
by  Tom Londe   Go to last post Go to first unread
Last post: 8/12/2019 11:39:05 PM(UTC)
Lansweeper Windows: Unauthorized Administrators (Built-in)
by  bnishan  
Go to last post Go to first unread
Last post: 8/12/2019 9:02:30 PM(UTC)
Report Center Top 5 Average RAM Usage
by  AlbertD   Go to last post Go to first unread
Last post: 8/12/2019 5:36:20 PM(UTC)
Lansweeper SWAPGS Report
by  Bginchereau  
Go to last post Go to first unread
Last post: 8/12/2019 2:25:22 PM(UTC)