Always on AG Dashboard report

First script:
Declare @databasename varchar(250)
SET @databasename =(Select DISTINCT Top 1 d.name from sys.databases d 
INNER JOIN master.sys.dm_hadr_database_replica_states drs
on d.replica_id = drs.replica_id)

if sys.fn_hadr_is_primary_replica (@databasename) <> 1
Begin
RAISERROR('This is not preferred primary replica',1,1)
END


Second scrpt:
USE master
GO

DECLARE @DB_count  int
DECLARE @tableHTML  NVARCHAR(MAX) ;  
 
SET @tableHTML =
N'<p> Hi Team </p>'+
N'<p> Some of the node(s) is/are not healthy. Please use following Database Availability report to find node/database name.</>'+    
    N'<H1> AG Databases Availability Report</H1>' +  
    N'<table border="1">' +  
    N'<tr><th> Availability Group </th><th> Server Name </th><th> Database Name </th>' +  
    N'<th> DB Synchronization State </th><th> Node health desc </th><th> log reuse wait desc </th><th> Last Commit time </th> </tr>' +  
    
    CAST ( ( SELECT td = ag.name, ' ',
   td = arcs.replica_server_name,' ',
   td = d.name,' ',
   td = drs.synchronization_state_desc, ' ',
   td = drs.synchronization_health_desc, ' ',
   td = d.log_reuse_wait_desc,' ',
   td = Convert(nvarchar,drs.last_commit_time,20)
FROM master.sys.databases d
INNER JOIN master.sys.dm_hadr_database_replica_states drs
ON d.database_id=drs.database_id
INNER JOIN master.sys.dm_hadr_availability_replica_cluster_states arcs
ON drs.replica_id=arcs.replica_id
INNER JOIN master.sys.availability_groups ag
ON ag.group_id=drs.group_id
ORDER BY arcs.replica_server_name ASC 
  
               
              FOR XML PATH('tr'), TYPE   
    ) AS NVARCHAR(MAX) ) +  
    N'</table>' ;

Set @DB_count = (Select count(drs.synchronization_health_desc)
FROM master.sys.databases d
INNER JOIN master.sys.dm_hadr_database_replica_states drs
ON d.database_id=drs.database_id
INNER JOIN master.sys.dm_hadr_availability_replica_cluster_states arcs
ON drs.replica_id=arcs.replica_id
where drs.synchronization_health_desc NOT LIKE 'HEALTHY' OR drs.synchronization_state_desc NOT IN ('SYNCHRONIZED','SYNCHRONIZING'))


IF @DB_count > 0

EXEC msdb.dbo.sp_send_dbmail 

  @profile_name='SQL Server Profile Name',
  @recipients= ‘Recipients email id’,
  @importance = 'High',
  @subject = 'CRITICAL-Node(s) is/are unhealthy',
  @body = @tableHTML,
  @body_format = 'HTML';
  

else

Print 'All nodes are healthy'
   

GO