→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Carsten1991
Engaged Sweeper
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 😉
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
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