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 TPM scanning
by  gene@sca   Go to last post Go to first unread
Last post: Yesterday at 10:40:24 PM(UTC)
Lansweeper Bulk AssetLock set
by  tcooper  
Go to last post Go to first unread
Last post: Yesterday at 6:24:15 PM(UTC)
Lansweeper Set AssetType based on Model?
by  tcooper   Go to last post Go to first unread
Last post: Yesterday at 6:16:57 PM(UTC)
Lansweeper Public IP Address
by  David Goodwin  
Go to last post Go to first unread
Last post: Yesterday at 4:57:14 PM(UTC)
Lansweeper Exchange Scan in v7 and DAG
by  Peter.Riederer   Go to last post Go to first unread
Last post: Yesterday at 8:42:48 AM(UTC)
Lansweeper Asset Scanning - Change Types
by  DNuhija  
Go to last post Go to first unread
Last post: 12/12/2019 5:40:47 PM(UTC)
Lansweeper Plundervolt
by  NWSF   Go to last post Go to first unread
Last post: 12/12/2019 5:10:14 PM(UTC)
Lansweeper MSI Package
by  Stefano Magri  
Go to last post Go to first unread
Last post: 12/12/2019 3:34:16 PM(UTC)