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
)
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