min(/IIS by Zabbix agent active/perf_counter_en["\APP_POOL_WAS({#APPPOOL})\Current Application Pool State"],3m)<>3
and {$IIS.APPPOOL.MONITORED:"{#APPPOOL}"}=1

last(/IIS by Zabbix agent active/perf_counter_en["\APP_POOL_WAS({#APPPOOL})\Current Application Pool State"])=3

SELECT p.eventid,p.name
FROM problem p
JOIN event_recovery er
ON p.eventid=er.eventid
WHERE p.r_eventid IS NULL;

DELETE er
FROM event_recovery er
JOIN problem p
ON p.eventid = er.eventid WHERE p.r_eventid IS NULL;

SELECT bs.database_name as dbname,
  [type],
  DATEDIFF(SECOND, bs.backup_finish_date, getdate()) as time_since_last_backup,
  (DATEDIFF(SECOND, bs.backup_start_date, bs.backup_finish_date)) as duration,
  db.recovery_model as db_recovery_model
FROM msdb.dbo.backupset as bs
LEFT JOIN sys.databases as db ON bs.database_name = db.name
WHERE bs.database_name not in (
  SELECT AGDatabases.database_name AS Databasename
  FROM sys.dm_hadr_availability_group_states States
  INNER JOIN master.sys.availability_groups Groups
    ON States.group_id = Groups.group_id
  INNER JOIN sys.availability_databases_cluster AGDatabases
    ON Groups.group_id = AGDatabases.group_id
  WHERE primary_replica != @@Servername OR primary_replica is NULL
) and db.name is not NULL
GROUP BY bs.database_name,
  backup_finish_date,
  [type],
  backup_start_date,
  db.recovery_model
HAVING backup_finish_date = (
  SELECT MAX(backup_finish_date)
  FROM msdb.dbo.backupset
  WHERE database_name = bs.database_name
    AND bs.type = [type]
)
ORDER BY bs.database_name

WITH AGPreferredDatabases AS (
  SELECT name
  FROM sys.databases
  WHERE sys.fn_hadr_backup_is_preferred_replica(name) = 1
)
SELECT bs.database_name as dbname,
  [type],
  DATEDIFF(SECOND, bs.backup_finish_date, getdate()) as time_since_last_backup,
  (DATEDIFF(SECOND, bs.backup_start_date, bs.backup_finish_date)) as duration,
  db.recovery_model as db_recovery_model
FROM msdb.dbo.backupset as bs
  LEFT JOIN sys.databases as db ON bs.database_name = db.name
  INNER JOIN AGPreferredDatabases agdb ON db.name = agdb.name
WHERE db.name is not NULL
GROUP BY bs.database_name,
  backup_finish_date,
  [type],
  backup_start_date,
  db.recovery_model
HAVING backup_finish_date = (
  SELECT MAX(backup_finish_date)
  FROM msdb.dbo.backupset
  WHERE database_name = bs.database_name
    AND bs.type = [type]
)
ORDER BY bs.database_name