Integrating SQL Monitor with Service Now

• 
  I am using SQL Monitor with Service Now. For some SQL Monitor alerts an email is sent to Service Now. Service Now has been set up to recognize who the email comes from and from that information creates an incident for the SQL DBA team queue. This works pretty good. But because we are doing this we have to have SQL Monitor set to NOT send an email when an alert has cleared otherwise it would go to Service Now. This would be more useful if the email alerts could be customized at the alert type, rather than globally. This is for various alert levels (high, medium, low) and when to send an email.
  
  I've also set up an interface with SQL Monitor comments. I have a SQL job that checks for new comments. It reads the comments in the SQL Monitor database. If the comment is formatted a specific way the job will send an email to Service Now as either an incident or request. Service Now knows from the email address, and also from specific text in the email whether to create an alert or a request and assign it to the SQL DBA group along with some other information specific to Service Now.

  sally753 November 20, 2016 16:45

  - 0 +
• 
  Hi Sally,
  I need your help in achieving this SQL monitor with ServiceNow configuration, can you please share the steps to achieve this.
  Thank you
  Avinash Bandaru
  

  AvinashSQLDBA October 02, 2020 05:06

  - 0 +
• 
  SQL monitor with ServiceNow configuration, can you please share the steps to achieve this?
  

  sanjay January 11, 2023 08:43

  - 0 +
• 
  Hi @sanjay
  
  You should find all the information you need here:
  
  https://documentation.red-gate.com/sm/metrics-alerts-and-notifications/configuring-alert-notifications/setting-up-webhook-notifications/integrating-with-servicenow
  

  Victoria W January 13, 2023 10:36

  - 0 +
• 
  Hi All,
  I found a solution to this finally, i have used webhooks to integrate.
  No limitations or no issue for now.
  please write to avinashbandari24@gmail.com for any help

  AvinashSQLDBA January 19, 2024 02:41

  - 0 +

Add comment

Please sign in to leave a comment.