Security Auditing for Lansweeper Metrics gathering and reporting.

[danielm]

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)

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