Error log Monitoring using asp.net window service with timer using Mom alerts concept

Question

Error log Monitoring using asp.net window service with timer using Mom alerts concept

coder rock 436

How to implement Mom Alerts concept for Error log Monitoring using C# asp.net window service with timer. I have plan to create one window service with timer for every 5 minutes using asp.net c# for error log monitoring. I am giving one example why I am implementing this concept suppose one login log table is there in my application since 2 hours no buddy is login then I need to get alert of this.

Currently I am storing my data into SQL server and My application made using asp.net web Api with angular.

My doubt is how to start this concept. Please suggest and give some sample code to achieve my requirement.

My doubt is how to start this concept need sample code

I have found some reference but not sure about this

There are tons of solutions like MS MOM, Tivoli, CA Unicenter, HP OpenView, and even NagIOS that you could use for this.

Reference URL : https://stackoverflow.com/questions/926333/exception-handling-in-a-client-server-architecture/926952#926952

AgaveJoe 1,510 Reputation points

2023-07-27T21:34:10.84+00:00

If I understand correctly, the use case is to query an error log every 5 minutes and send a notification.

This can be handled easily with Windows Task Scheduler or SQL Agent.
coder rock 436 Reputation points

2023-07-27T23:00:48.7+00:00

Hi AgaveJoe,

I know this can be done by Task Scheduler or SQL Agent. please can you share the code for how to send a notification? my boss told to me implement like Mom alerts concept.

take one example i have loginlog table

No one login from portal since one hour then need to sent notification to me that no login since from 1 hour.
AgaveJoe 1,510 Reputation points

2023-07-28T11:02:32.8433333+00:00

please can you share the code for how to send a notification?

What kind of notification? An email? Text message? A real-time dashboard?

The Microsoft Operation Manager displays alerts in a desktop application window. Are you tasked with creating a Web Application application that displays alerts?

No one login from portal since one hour then need to sent notification to me that no login since from 1 hour.

We have no idea how security works in your application. Do you store the login date and time? The last access date and time?
coder rock 436 Reputation points

2023-07-28T13:57:10.98+00:00

Thanks for your valuable reply.

What kind of notification? An email? Text message? A real-time dashboard?

We need to send email notification. currently we not using any dashboard just calling window service have to do this job.

We have no idea how security works in your application. Do you store the login date and time? The last access date and time?

I am creating new separate window service application for error log monitory system, dont worry of security because its new application and to calling multiple databases, Yes we are storing the logindatetime and logoutdatetime check below

Id EmpId LogInt LogOut

1 1 2021-06-24 07:08:12.477 2021-06-24 08:45:49.317

If you share code will be great thanks
coder rock 436 Reputation points

2023-07-28T14:28:23.0433333+00:00

What kind of notification? An email? Text message? A real-time dashboard?

Emai notification, no dashboard currently i am creating new windows application project for this error log monitoring. No Dashboard nothing only service will do all the things by notification.

The Microsoft Operation Manager displays alerts in a desktop application window. Are you tasked with creating a Web Application application that displays alerts?

Not sure, I am creating new separate application for window service to monitoring error log notification and file storing into folder.

We have no idea how security works in your application. Do you store the login date and time? The last access date and time?

This is new applicatoin for window service and there no point of security here.

Yes i have login date and time storing like below

Id EmpId LogInt LogOut

1 1 2021-06-24 07:08:12.477 2021-06-24 08:45:49.317

If you share code will be great thanks
AgaveJoe 1,510 Reputation points

2023-07-28T15:06:43.5633333+00:00

We need to send email notification.

.NET has the SmtpClient for sending emails. The official documentation has sample code. Also, an internet internet search will provide plenty of code examples.

SmtpClient Class

There are also libraries like SendGrid. The key is you need to know details of the email service you are using.

https://www.twilio.com/blog/send-emails-using-the-sendgrid-api-with-dotnetnet-6-and-csharp

Accepted answer

0 additional answers

Your answer

AgaveJoe 1,510 Reputation points

2023-07-27T21:34:10.84+00:00

If I understand correctly, the use case is to query an error log every 5 minutes and send a notification.

This can be handled easily with Windows Task Scheduler or SQL Agent.
coder rock 436 Reputation points

2023-07-27T23:00:48.7+00:00

Hi AgaveJoe,

I know this can be done by Task Scheduler or SQL Agent. please can you share the code for how to send a notification? my boss told to me implement like Mom alerts concept.

take one example i have loginlog table

No one login from portal since one hour then need to sent notification to me that no login since from 1 hour.
AgaveJoe 1,510 Reputation points

2023-07-28T11:02:32.8433333+00:00

please can you share the code for how to send a notification?

What kind of notification? An email? Text message? A real-time dashboard?

The Microsoft Operation Manager displays alerts in a desktop application window. Are you tasked with creating a Web Application application that displays alerts?

No one login from portal since one hour then need to sent notification to me that no login since from 1 hour.

We have no idea how security works in your application. Do you store the login date and time? The last access date and time?
coder rock 436 Reputation points

2023-07-28T13:57:10.98+00:00

Thanks for your valuable reply.

What kind of notification? An email? Text message? A real-time dashboard?

We need to send email notification. currently we not using any dashboard just calling window service have to do this job.

We have no idea how security works in your application. Do you store the login date and time? The last access date and time?

I am creating new separate window service application for error log monitory system, dont worry of security because its new application and to calling multiple databases, Yes we are storing the logindatetime and logoutdatetime check below

Id EmpId LogInt LogOut

1 1 2021-06-24 07:08:12.477 2021-06-24 08:45:49.317

If you share code will be great thanks
coder rock 436 Reputation points

2023-07-28T14:28:23.0433333+00:00

What kind of notification? An email? Text message? A real-time dashboard?

Emai notification, no dashboard currently i am creating new windows application project for this error log monitoring. No Dashboard nothing only service will do all the things by notification.

The Microsoft Operation Manager displays alerts in a desktop application window. Are you tasked with creating a Web Application application that displays alerts?

Not sure, I am creating new separate application for window service to monitoring error log notification and file storing into folder.

We have no idea how security works in your application. Do you store the login date and time? The last access date and time?

This is new applicatoin for window service and there no point of security here.

Yes i have login date and time storing like below

Id EmpId LogInt LogOut

1 1 2021-06-24 07:08:12.477 2021-06-24 08:45:49.317

If you share code will be great thanks
AgaveJoe 1,510 Reputation points

2023-07-28T15:06:43.5633333+00:00

We need to send email notification.

.NET has the SmtpClient for sending emails. The official documentation has sample code. Also, an internet internet search will provide plenty of code examples.

SmtpClient Class

There are also libraries like SendGrid. The key is you need to know details of the email service you are using.

https://www.twilio.com/blog/send-emails-using-the-sendgrid-api-with-dotnetnet-6-and-csharp

Answer 1

Lan Huang-MSFT 30,186 Microsoft External Staff

Hi @mohd mazhar khan,

I found a document that might do what you want.

This tutorial demonstrates how to create a Windows service app in Visual Studio that writes messages to the event log, including how to implement a timer component.

https://learn.microsoft.com/en-us/dotnet/framework/windows-services/walkthrough-creating-a-windows-service-application-in-the-component-designer

Tutorial: Create a Windows service app - GitHub

Some other useful links:

https://stackoverflow.com/a/41682223

https://stackoverflow.com/a/12886071

Best regards,
Lan Huang

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

coder rock 436 Reputation points

2023-07-30T12:13:24.66+00:00

Thanks and waiting form your reply

coder rock 436

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Linq;
using System.ServiceProcess;
using System.Text;
using System.Threading.Tasks;
using System.Timers;
using System.Runtime.InteropServices;

namespace ErrorLognMonitory
{
    public partial class MyNewService : ServiceBase
    {
        public MyNewService()
        {
            InitializeComponent();
            eventLog1 = new System.Diagnostics.EventLog();
            if (!System.Diagnostics.EventLog.SourceExists("MySource"))
            {
                System.Diagnostics.EventLog.CreateEventSource(
                    "MySource", "MyNewLog");
            }
            eventLog1.Source = "MySource";
            eventLog1.Log = "MyNewLog";
             
        }

        protected override void OnStart(string[] args)
        {
            // Update the service state to Start Pending.
            ServiceStatus serviceStatus = new ServiceStatus();
            serviceStatus.dwCurrentState = ServiceState.SERVICE_START_PENDING;
            serviceStatus.dwWaitHint = 100000;
            SetServiceStatus(this.ServiceHandle, ref serviceStatus);

             eventLog1.WriteEntry("In OnStart2b.");
            Timer timer = new Timer();
            timer.Interval = 60000; // 60 seconds
            timer.Elapsed += new ElapsedEventHandler(this.OnTimer);
            timer.Start();

            // Update the service state to Running.
            serviceStatus.dwCurrentState = ServiceState.SERVICE_RUNNING;
            SetServiceStatus(this.ServiceHandle, ref serviceStatus);

        }
        private int eventId = 1;
        public void OnTimer(object sender, ElapsedEventArgs args)
        {
            // TODO: Insert monitoring activities here.
            eventLog1.WriteEntry("Monitoring the System", EventLogEntryType.Information, eventId++);

          
        }

        protected override void OnStop()
        {
            eventLog1.WriteEntry("In OnStop.");
            // Update the service state to Stop Pending.
            ServiceStatus serviceStatus = new ServiceStatus();
            serviceStatus.dwCurrentState = ServiceState.SERVICE_STOP_PENDING;
            serviceStatus.dwWaitHint = 100000;
            SetServiceStatus(this.ServiceHandle, ref serviceStatus);

            // Update the service state to Stopped.
            serviceStatus.dwCurrentState = ServiceState.SERVICE_STOPPED;
            SetServiceStatus(this.ServiceHandle, ref serviceStatus);
        }
        protected override void OnContinue()
        {
            eventLog1.WriteEntry("In OnContinue.");
        }

        public enum ServiceState
        {
            SERVICE_STOPPED = 0x00000001,
            SERVICE_START_PENDING = 0x00000002,
            SERVICE_STOP_PENDING = 0x00000003,
            SERVICE_RUNNING = 0x00000004,
            SERVICE_CONTINUE_PENDING = 0x00000005,
            SERVICE_PAUSE_PENDING = 0x00000006,
            SERVICE_PAUSED = 0x00000007,
        }

        [StructLayout(LayoutKind.Sequential)]
        public struct ServiceStatus
        {
            public int dwServiceType;
            public ServiceState dwCurrentState;
            public int dwControlsAccepted;
            public int dwWin32ExitCode;
            public int dwServiceSpecificExitCode;
            public int dwCheckPoint;
            public int dwWaitHint;
        };

        [DllImport("advapi32.dll", SetLastError = true)]
        private static extern bool SetServiceStatus(System.IntPtr handle, ref ServiceStatus serviceStatus);
    }
}

Thanks for your valuable reply

I have impletemented according your given link url above code and working fine, below is Error log monitoring System working fine Below whenService start and its running

User's image

Also error log is coming every minute to Event viewer

User's image

In OnTimer mehotd i want to sent email alert notification and send email to my email id by checking one sql table if data does not have record for today then send email to me. I dont know how to call sql server connect string here in service.

Also i have doubt why we are using below code please can you explain me mynewservice mehtod, for below code is mandatory for my requirments?

we have done this above all work into locally in future need to deploy into production system can you explain if possible how?.

Thanks and waiting form your reply

Lan Huang-MSFT 30,186 Reputation points Microsoft External Staff

2023-07-31T05:25:18.2833333+00:00
Hi @mohd mazhar khan,

I dont know how to call sql server connect string here in service.

You need to configure Windows service account and permissions in SQL Server.

How to access a SQL database from a Windows service?

i have doubt why we are using below code please can you explain me mynewservice mehtod, for below code is mandatory for my requirments?

The documentation states that this code is used to add custom event logging functionality.

EventLog Class:Provides interaction with Windows event logs.

EventLog.CreateEventSource Method:Establishes an application as able to write event information to a particular log on the system.

The comments in the code below should help you understand better.

// Create the source, if it does not already exist. if(!EventLog.SourceExists("MySource")) { //An event log source should not be created and immediately used. //There is a latency time to enable the source, it should be created //prior to executing the application that uses the source. //Execute this sample a second time to use the new source. EventLog.CreateEventSource("MySource", "MyNewLog"); } // Create an EventLog instance and assign its source. EventLog myLog = new EventLog(); myLog.Source = "MySource";

Share via

Error log Monitoring using asp.net window service with timer using Mom alerts concept

0 additional answers

Your answer