SQL Abfragen

SELECT 
  date(alarm_log.timedate), 
  COUNT(alarm_log.source)
FROM 
  fms01.alarm_log
WHERE 
  alarm_log.source LIKE 'U_Phoenix_101%' AND 
  alarm_log.messages LIKE '%Increase%'
GROUP BY
  date(alarm_log.timedate)
ORDER BY
  date(alarm_log.timedate) ASC
;





SELECT 
  alarm_log.timedate, 
  alarm_log.source,
  alarm_log.messages
FROM 
  fms01.alarm_log
WHERE 
  alarm_log.source LIKE '%PAC%02%' AND 
  alarm_log.messages NOT LIKE '%Increase%'

ORDER BY
  alarm_log.timedate ASC
;

SELECT 
  event_log.timedate, 
  event_log.source,
  event_log.messages
FROM 
  fms01.event_log
WHERE 
  event_log.messages LIKE '%state%' AND
  event_log.source LIKE '%AG%' AND
  event_log.messages NOT LIKE '%Unit Working%'
ORDER BY
  event_log.timedate ASC
;