Answered by:
Own SCOM alert

Question
-
I have an application and some of the application events need to be send as an alert.
We are using SCOM and I would like to send these alerts using SCOM.
Unfortunately these events are not part of any standard management pack.
Any help of references should be great help.Monday, March 10, 2014 6:32 PM
Answers
-
Hi
Ok, you have all your logs written in a SQL DB and you would like to check basically the DB. I suggest to write a script monitor like in this example here...
http://contoso.se/blog/?p=1346
Of course you need to adjust the SQL query...
Cheers,
Blog: http://blog.scomfaq.ch
- Marked as answer by Juke Chou Monday, March 24, 2014 3:09 AM
Tuesday, March 11, 2014 9:35 PM
All replies
-
Hi,
If your application write the Events to a Windows Event Log please have a look on:
http://jimmoldenhauer.blogspot.co.at/2013/03/scom-2012-how-to-generate-alerts-from.html
Christoph Maresch | My blogs: blog.cmaresch.at | XING: Christoph Maresch | Linkedin: Christoph Maresch
Monday, March 10, 2014 8:06 PM -
Hi
As I understand you would like to create alerts from certain Events e.g. Windows Events. You either can create a rule or a Monitor http://technet.microsoft.com/en-us/library/hh457603.aspx . You can create alerts from different sources like here http://technet.microsoft.com/en-us/library/hh457593.aspx . As I mentioned, if you would like to create an alert from a Windows Event you could try to create an Event Monitor http://technet.microsoft.com/en-us/library/hh457559.aspx like a Manual reset http://technet.microsoft.com/en-us/library/hh457598.aspx .
If you would like to create a rule I suggest starting here http://technet.microsoft.com/en-us/library/cc180957.aspx .
If you Need to Monitor a log file from an application I suggest use the NiCE Log File Library http://stefanroth.net/2014/02/24/scom-2012-nice-log-file-library-mp-monitoring-robocopy-log-file/
In all cases the server needs to be monitored (have SCOM agent installed).
Cheers,
Stefan
Blog: http://blog.scomfaq.ch
Monday, March 10, 2014 8:21 PM -
Thanks Stefan.
These events/exceptions are being logged to SQL database. Can we monitor the log database ? Any pointers ?
Thank you
Monday, March 10, 2014 10:27 PM -
As I understand, one way to write the Events to Event log and then subscribe to these events from SCOM ? Since I do not have option to write these events to event log, what other options do I have ? Can I monitor these events from SQL Database.
- Edited by CloudJunkie Monday, March 10, 2014 11:07 PM
Monday, March 10, 2014 11:04 PM -
Hi,
Based on my unserstanding, if we could not get those event directly from event logs, then we could not create Windows Event type monitor to monitor it. And as we know, we can create monitors and rules to generate alerts, for your requirement, I think we need to create Scripting type monitor, and we should get out event information from SQL database with the script.
For the SQL scripting issue, please also contact Windows SQL forum and the official scripting guys forum.
Regards,
Yan Li
Regards, Yan Li
Tuesday, March 11, 2014 5:58 AM -
Would you suggest text log option would be better ? and any challenges with that implementation.Tuesday, March 11, 2014 12:54 PM
-
You can write tsql queries and create a SCOM custom monitor The below may help http://matthewlong.wordpress.com/2012/06/23/query-a-database-without-scripting-as-part-of-scom-monitoring-the-system-oledbprobe-module/ http://rockyprogress.wordpress.com/2011/09/26/scom-monitoring-using-a-database-query/
Http://blog.theinfraguys.com | Please remember to click “Mark as Answer” on my answer if it helps. :)
Tuesday, March 11, 2014 3:41 PM -
Hi
Ok, you have all your logs written in a SQL DB and you would like to check basically the DB. I suggest to write a script monitor like in this example here...
http://contoso.se/blog/?p=1346
Of course you need to adjust the SQL query...
Cheers,
Blog: http://blog.scomfaq.ch
- Marked as answer by Juke Chou Monday, March 24, 2014 3:09 AM
Tuesday, March 11, 2014 9:35 PM