Create Event Report for ID 7030

[Carsten1991]

Hi I want to create a report for the Service Control Manager Event ID 7030 in dashboard from the last week?
We use Lansweeper in version 5.2

Thanks for Help 😉

[Daniel_B · Accepted solution]

If this event is a warning event, you'll need to enable scanning of warning events under Configuration\Server options, section Eventlog scanning. Note: This can increase the size of your database quickly and isn't recommended if you have installed Lansweeper on SQL Compact with more than 50-100 scanned assets.

Verify that this event gets scanned by checking the Event log tab of a computer's asset page which generates these events.

Create a custom report with the following SQL query and use it on the Data Report Widget on your Dashboard:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblNtlog.Eventcode,
  tblNtlog.TimeGenerated,
  tblNtlogMessage.Message
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblNtlog On tblAssets.AssetID = tblNtlog.AssetID
  Inner Join tblNtlogSource On tblNtlogSource.SourcenameID =
    tblNtlog.SourcenameID
  Inner Join tblNtlogMessage On tblNtlogMessage.MessageID = tblNtlog.MessageID
Where tblNtlog.Eventcode = 7030 And tblNtlog.TimeGenerated > GetDate() - 7 And
  tblNtlogSource.Sourcename = 'Service Control Manager' And
  tblAssetCustom.State = 1
Order By tblNtlog.TimeGenerated Desc

For instructions on how to run a report, please refer to the following note: http://www.lansweeper.com/Forum/yaf_postst9882_How-to-run-a-report.aspx