I did try removing database from both node then remove the BAG from first node and second node respective. Somehow, BAG has been dropped from first node but not on...

Never mind. I found the solution.
Updated the query using covnert function:

select @qry='set nocount on;select BatchID ' + @column1name + 
     ' ,UserName,FQFilename,
             CONVERT(VARCHAR(20),DateDownloaded,20) as...

Thanks all for your quick response.
Statistics are updating every day. I can work on changing data type from Nvarchar to Varchar. Is there any alternative for this code/

Anyhow, i found the solution.

DECLARE @sdate DATETIME
SET @sdate = dateadd(D,-15,getdate())
DECLARE @edate DATETIME
SET @edate = getdate()

exec sp... @sdate, @edate

Thanks all.
<b

Thanks Lowell for your response. But, this article is quit different than our requirement.

Here is an example:

3 databases in 3 AG.

TestAG1, TestAG2 and TestAG3.

I need a script which will monitor...

Can you please illustrate through the example?

I was trying to use the column (P.propertyvaluesstring.value('//ApplicationPro[1]/text()', 'VARCHAR(50)') AS ApplicationPro) as you mentioned in the view but i am getting error can't call...

Thanks for reply. But, how can i use that column into main SP?

I am extremely sorry about the SQL plan. By mistake, I have attached other execution plan. Please find corrected sql plan.