Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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
20:58, 27 Jul 2016

Tags

Classifications

Public