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
1
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
jseet
#1jseet Member Posts: 4  
posted: 3/8/2022 3:27:58 PM(UTC)
Originally Posted by: Nick.VDB Go to Quoted Post
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


This report appears to be broken in the new version of lansweeper. Currently running v9.1.20.2 and the report only shows activity from 3 months ago.

Active Discussions

Lansweeper mail reports
by  Andy.S   Go to last post Go to first unread
Last post: 7/1/2022 2:38:18 PM(UTC)
Lansweeper Adding an "Employee ID" column to an asset report
by  ABaker  
Go to last post Go to first unread
Last post: 6/30/2022 3:06:54 PM(UTC)
Lansweeper Firefox 102 & ESR 91.11
by  Esben.D   Go to last post Go to first unread
Last post: 6/30/2022 8:12:07 AM(UTC)
Lansweeper Performance report not shows result
by  NoraD  
Go to last post Go to first unread
Last post: 6/28/2022 7:52:27 AM(UTC)
Lansweeper Duplicate AD Users
by  Randy Costa   Go to last post Go to first unread
Last post: 6/27/2022 5:25:04 PM(UTC)
Lansweeper Multiple Devices Owned by Users (asset relations)
by  Adrian Scott  
Go to last post Go to first unread
Last post: 6/22/2022 5:34:51 PM(UTC)