Submit a ticketCall us

AnnouncementsWeb Help Desk Integrations eCourse

Looking to reduce response times? Sign up for our eCourse to learn how integrating Web Help Desk with Dameware Remote Support, Network Configuration Manager, Network Performance Monitor, and Server & Application Monitor can improve communication efficiencies.

Register here.

Home > Success Center > Server & Application Monitor (SAM) > Create a Windows Event Log Monitor report

Create a Windows Event Log Monitor report

Table of contents

Updated: July 28, 2016

Overview

This article aims to help build a report that will provide the matches for one or more matches for a Windows Event Log Monitor.

Environment

Steps

1. Go to Settings > Manage Report.

2. Click Create New Report.

3. Select Custom Table and click SELECT AND CONTINUE.

4. Select Advanced DataBase Query (SQL, SWQL).

5. Select SQL and paste the following query:

 

select * from dbo.apm_windowsEvent_Detail where ComponentID IN ('{ComponentID','{ComponentID'}) AND DATEDIFF(day,TimeGeneratedUTC,getdate()) <31

 

Note: Replace {ComponentID} with the internal ID(s) of the Windows Event Log Monitor(s) you wish to report on.  To find the ID, simply open the Monitor's Details Page and note the number at the end of the URL in your Web Browser's address bar.

 

6. Click ADD TO LAYOUT.

7. Click Add Column.

8. Select all of the columns and click ADD COLUMN.

9. Modify as needed and click SUBMIT.

10. Give the Report a title and click Next

11. Continue clicking Next until the wizard is complete.

 

 

Last modified

Tags

Classifications

Public