• 
  Hi Peter, you can look in the alert.notifications table to see if the alert was ever fired, joining across to the alert table on the alert id. It might be best to get in contact with Support directly. Please remember to attach the log files.

  Russell D May 15, 2020 08:58

  - 0 +
• 
  Thanks, @Russell D.  I wrote the following SQL based on your guidelines:
  
  

  SELECT TOP(10)
  	at.Name AS AlertTypeName
  	,a.AlertId
  	,a.TargetObject
  	,a.Raised
  	,n.NotificationDate
  	,n.NotificationType
  FROM
  	alert.Alert AS a
  	INNER JOIN alert.Alert_Type AS at
  		ON(a.AlertType = at.AlertType)
  	LEFT JOIN alert.Notifications AS n
  		ON(a.AlertId = n.AlertId)
  	--LEFT JOIN alert.
  WHERE
  	at.Name = N'Job failing'
  ORDER BY
  	a.AlertId DESC

  I'm assuming that NULL for NotificatonDate and NotificationType means no notification was sent.  Before submitting a support ticket wondering if you could help me navigate the myriad log files.  Where would I look for issue related to notifications not being sent?
  
  Thanks,
  
  -Peter
  
  PS Any tips on parsing/interpreting your "fancy" Date column values (e.g. 637249573070000000)?

  PeterDanielsCRB May 15, 2020 14:32

  - 0 +
• 
  Hi Peter, these are in ticks. There's a function included in the database TicksToDateTime, can be called with selecting into, eg
  

  <p>select [AlertId]</p><p>,[AlertType]&nbsp;&nbsp;&nbsp;&nbsp;</p><p>,[TargetObject]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p><p>,[Read]&nbsp;&nbsp;&nbsp;&nbsp;</p><p>,utils.TicksToDateTime([ReadDate]) as 'Read Date'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p><p>,[SubType]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p><p>,[LastUpdate]&nbsp;&nbsp;&nbsp;&nbsp;</p><p>,utils.TicksToDateTime([Raised]) as 'Raised Date'&nbsp;&nbsp;&nbsp;&nbsp;</p><p>,[LastSeverity]&nbsp;&nbsp;&nbsp;&nbsp;</p><p>,[WorstSeverity]&nbsp;&nbsp;&nbsp;</p><p>,[Cleared]</p><p>,utils.TicksToDateTime([ClearedDate]) as 'Cleared Date'</p><p>&nbsp;,[LastComment]</p><p>,[RootCir]</p><p>,[GroupCir]</p><p>from [alert].[Alert]</p><p>go</p>

  hm sorry for the formatting, I've no idea why the code blocks are like that.

  Russell D May 18, 2020 09:01

  - 0 +
• 
  Thanks, @Russell D , for the fn tip (TicksToDateTime).  Is this in the docs anywhere?  Also, wondering if you might have a follow-up to my request for which logs to look at (and what to look for in them) for failed email notification.  Here is what I see from my query:
  
  
  

  PeterDanielsCRB May 18, 2020 15:23

  - 0 +
• 
  It's not documented because we don't really Support querying the database directly (though you are free to do so). If there's a null in the Notification date then a Notification was never sent, even if the email was sent but failed to get to its destination, there would be a time in this field.
  
  You can look in the basemonitor.log for email failures.

  Russell D May 20, 2020 10:25

  - 0 +
• 
  Thanks, @Russell D . That makes sense (not documented due to not supporting direct querying of the DB).
  
  I looked at "base monitor.log" file (found it in .\localhost\BaseMonitor).  Didn't see anything regarding notification/email failure during the time frame when this occurred.  Might be time for a support case.

  PeterDanielsCRB May 20, 2020 17:13

  - 0 +
• 
  I think so, just fire the logs in to Support and we can check it out after they've picked it up.

  Russell D May 21, 2020 07:43

  - 0 +

Add comment

Please sign in to leave a comment.