|
AutoResolve
an Alert from a TicketingSystem (Example)
This Example shows how you can send an Alert to a
Ticket-System and AutoResolve the Alert as soon as the Ticket is closed. We
don't use any connectors, only Scripts.
This is only an Example for a Startup. You have to analyse the
Database Schema of your Ticketing System and you have to make sure, that you can
send the ALERT Guid with the Notification. For Demonstration I included a sample
Database.
This Example has 3 Elements:
1) the Rule who creates the Alert.
Nothing special here, you can use every Rule you like....
2) The Alert Rule, who sends the Alert Information to the
Ticket Database. (Import the Example Database into your SQL Server, if you want
to see the Example running)
3)The EventRule which reads in a 2 Minute Schedule the Ticket
DataBase and compares the Status of the Ticket and the Alert Guid with the open
Alerts in MOM. If we have a match, the Alert in MOM will be resolved.
Prozess Flow:
(click picture to enlarge)
Installation:
1) Import the Management Pack to MOM
2) Restore the Example TicketDatabase Backup
3) Change in Script CreateTicket the DataSource to your
SQLServer Name and
the User ID and Password.
"Provider=SQLOLEDB;Data Source=YourSQLServer;"
& _
"Trusted_Connection=Yes;Initial Catalog=TicketSystem;" & _
"User ID=Domain\User;Password=YourPAss;"
4) Change in Script ReadTicketDB the same
Attributes as in point 3.
5) Assign the RuleGroup to a ComputerGroup you like ..(with a Test Server
defined)
Testing:
Test the Rules with stopping the Print spooler on
the Test Server. You should get a Critical Alert and a new Entry in the Example
TicketDatabase.
If you set the TicketStatus to 1 for the new record, the Alert should be
resolved wtihin 2 Minutes in MOM.
Implementation Scenario:
You have to adapt the 2 Script to your Ticketing system schema. Copy the Alert
Rule to all Groups you like. Best Idea is to look for existing notification
alerts "out of the box". With this changes you can send each alert which is
critical or higher to your TicketingSystem and resolve automatically the Alert
if the ticket is closed.
I'm sure there is a lot of improvement possible, but enough to
get the Idea...
Michael Müller
www.momsolutions.org
|
