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 Exclude non-windows assets from scanning by assetname
by  rapheren   Go to last post Go to first unread
Last post: Today at 1:18:12 PM(UTC)
Lansweeper HTTPS Certifikate untrusted
by  pskup  
Go to last post Go to first unread
Last post: Today at 9:20:07 AM(UTC)
Lansweeper Migrate to new host but without SQL
by  pskup   Go to last post Go to first unread
Last post: Today at 9:03:14 AM(UTC)
Lansweeper Object reference error after updating to 10.2.0.0
by  Erik.T  
Go to last post Go to first unread
Last post: Today at 8:10:25 AM(UTC)
Lansweeper Detect Docking Stations
by  CyberCitizen   Go to last post Go to first unread
Last post: Today at 12:59:42 AM(UTC)
Lansweeper Custom reporting - Asset Groups and AD Description
by  rbshawn  
Go to last post Go to first unread
Last post: Yesterday at 10:54:10 PM(UTC)
Lansweeper A FIX for an odd Scan Error WMI/DCOM from scanning server
by  danielm   Go to last post Go to first unread
Last post: Yesterday at 10:14:44 PM(UTC)
Lansweeper Purging helpdesk tickets older than 5 years
by  SentryP  
Go to last post Go to first unread
Last post: Yesterday at 6:13:37 PM(UTC)