SQL Query-Twilio-Down

How to find the  Validate from the log that Twilio API is down

SELECT * FROM LOG WHERE LOGGER LIKE '%ha.ipc%’ AND EXCEPTION LIKE '%Twilio API is down or could not validate%' ORDER BY 1 DESC

select * from Notification_Actions_Queue nq inner jOIN DBO.NOTIFICATION_ITEM ni (NOLOCK) ON nq.ItemID = ni.iTEMid INNER JOIN DBO.NotificationActionItem_Type nt(nolock) ON nI.ActionItemTypeID = NT.ActionItemTypeID WHERE ITEMS = 'Appointment Reminder' AND cast(ScheduledDTTM as date) >= 'mm/dd/yyyy' AND cast(ScheduledDTTM as date) <= 'mm/dd/yyyy'and methodtypeid=2 AND nq.ORGANIZATIONID =102

How to find the  Validate Undelivered or Restricted SMS

select ProviderTransactionStatus,* from Message_Transaction_Details where cast(ProviderTransactionClientDateTime as date) = '01/24/2023' and messagetype ='SMS' and ProviderTransactionStatus NOT in ('Undelivered', 'Restricted')

Patient Preferred Method Query

SELECT PP.UserId,PP.Organizationid,PP.PrefCommMethodTypeId,PC.PrefCommMethod

FROM Patient_Preferred_Communication PP WITH(NOLOCK)

JOIN Preferred_Communication_MethodType PC WITH(NOLOCK) ON PP.PrefCommMethodTypeId=PC.PrefCommMethodTypeId

WHERE PP.UserID=1249 and PP.organizationid=100 and PP.Isactive='Y'