Notification

Icon
Error

Security Auditing for Lansweeper Metrics gathering and reporting. - Report to show current metrics database details that may be reported.

Posted: Friday, January 31, 2020 5:14:43 AM(UTC)
danielm

danielm

Member Original PosterPosts: 174
0
Like
This is technically what is shown on the lansweeper Configuration/Privacy settings page, but its nice to have a report incase you need to have someone who is responsible for auditing security violations or data leakage access to that via report. (ps its opt out by default. unclick if so desired)


Code:

Select Top 1000000 tblMetricsQueryDefinition.*,
  tblMetricsQueryDefinition.MetricsQueryDefinitionId As
  MetricsQueryDefinitionId1,
  tblMetricsQueryDefinition.Description As Description1,
  tblMetricsQueryDefinition.PrerequisiteSql As PrerequisiteSql1,
  tblMetricsQueryDefinition.Sql As Sql1,
  tblMetricsQueryDefinition.Title As Title1,
  tblMetricsQueryDefinition.LastUpdateDate As LastUpdateDate1,
  tblMetricsQueryDefinition.Data As Data1
From tblMetricsQueryDefinition

Active Discussions

Lansweeper Report on clients with no LSAgent
by  RobertB   Go to last post Go to first unread
Last post: Today at 6:55:32 PM(UTC)
Lansweeper Report for one asset - a Router - need 5 fields only in report
by  milty  
Go to last post Go to first unread
Last post: Yesterday at 4:51:48 PM(UTC)
Lansweeper Lansweeper report to match computer name
by  RC62N   Go to last post Go to first unread
Last post: 2/19/2020 5:02:27 PM(UTC)
Lansweeper Distinct user logins per PC
by  Bruce Garoutte   Go to last post Go to first unread
Last post: 2/17/2020 6:36:29 PM(UTC)
Lansweeper Software version report issue
by  RC62N  
Go to last post Go to first unread
Last post: 2/17/2020 4:07:20 PM(UTC)
Lansweeper Patch Tuesday - Exclude Win 2008 & Win7
by  doone128   Go to last post Go to first unread
Last post: 2/17/2020 1:34:36 PM(UTC)
Lansweeper Performance statistics combined into one report
by  djs1789  
Go to last post Go to first unread
Last post: 2/15/2020 1:50:32 AM(UTC)