SOLVED

ASR Reporting

%3CLINGO-SUB%20id%3D%22lingo-sub-565772%22%20slang%3D%22en-US%22%3EASR%20Reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-565772%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22public-DraftStyleDefault-block%20public-DraftStyleDefault-ltr%22%3E%3CSPAN%3Ea)%20How%20to%20Monitor%20VM%20that%20are%20ASR%20Protected%20to%20understand%20when%20they%20are%20offline%20in%20Primary%20Region%20and%20the%20DR%20Team%20has%20to%20enable%20ASR%3F%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22public-DraftStyleDefault-block%20public-DraftStyleDefault-ltr%22%3E%3CSPAN%3Eb)%20Any%20DR%20report%20that%20provides%20information%20on%20DR%20performed%20for%20a%20VM%20in%20Azure%3F%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-565772%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Site%20Recovery%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1125336%22%20slang%3D%22en-US%22%3ERe%3A%20ASR%20Reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1125336%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239477%22%20target%3D%22_blank%22%3E%40Clive%20Watson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20create%20a%20query%20to%20see%20%3CSPAN%3EDaily%20data%20change%20rate%20I%20can't%20find%20a%20value%2Fvariable%20to%20use%2C%20thanks.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-566278%22%20slang%3D%22en-US%22%3ERe%3A%20ASR%20Reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-566278%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F180469%22%20target%3D%22_blank%22%3E%40Admin%20O365%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EASR%20can%20send%20its%20diagnostic%20data%20to%20Log%20Analytics%20from%20there%20you%20can%20see%20status%20and%20messages%20etc...%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20docs%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Fplatform%2Fcollect-azure-metrics-logs%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Fplatform%2Fcollect-azure-metrics-logs%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3EAzureDiagnostics%0A%7C%20where%20OperationName%20startswith%20%22AzureSiteRecoveryEvent%22%0A%7C%20extend%20parseJSON%20%3D%20parse_json(healthErrors_s)%0A%7C%20summarize%20%20count()%20by%20OperationName%20%2C%20ResourceProvider%2C%20affectedResourceName_s%2C%20tostring(parseJSON.%5B0%5D.errorMessage)%20%3C%2FPRE%3E%0A%3CP%3EYou%20can%20run%20this%20query%20in%20the%20demo%20workspace%20from%20%3CA%20href%3D%22https%3A%2F%2Fportal.loganalytics.io%2FDemo%3Fq%3DH4sIAAAAAAAAA12PvWrDQBCEe4PfYXElgTB5gRSCqAn4B7sMRmxOY%252BmMdWd2V3Ik8vDJEewi3cDMx8yU8yB489yGqOadLhffdO8goN0NwuZj2HIPUmMxvXvraFUm5ugNB7g4QqZqRLBVQvFlCA3dWBTvx92WXv90fdEYsg58ta4SiaK15gnQoe9Z%252FAwiF4dgWU6f07%252Fugg7QOIjDXuLoG0hBfD7DGZqHk4K1FmS%252FN8SHNntOWH%252B8nNZInRuocoucfgCUNAQR9QAAAA%253D%253D%26amp%3Btimespan%3DP7D%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehere%3C%2FA%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhich%20produces%20this%20output%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F113278iBC5B6EF8BDA53EBD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Annotation%202019-05-14%20193614.png%22%20title%3D%22Annotation%202019-05-14%20193614.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor
a) How to Monitor VM that are ASR Protected to understand when they are offline in Primary Region and the DR Team has to enable ASR?
b) Any DR report that provides information on DR performed for a VM in Azure?
5 Replies
Highlighted
Best Response confirmed by Admin O365 (Frequent Contributor)
Solution

Hello @Admin O365 

 

ASR can send its diagnostic data to Log Analytics from there you can see status and messages etc...

 

See docs: https://docs.microsoft.com/en-us/azure/azure-monitor/platform/collect-azure-metrics-logs 

 

AzureDiagnostics
| where OperationName startswith "AzureSiteRecoveryEvent"
| extend parseJSON = parse_json(healthErrors_s)
| summarize  count() by OperationName , ResourceProvider, affectedResourceName_s, tostring(parseJSON.[0].errorMessage) 

You can run this query in the demo workspace from here  

 

Which produces this output 

 

Annotation 2019-05-14 193614.png

Highlighted

@Clive Watson 

 

Is it possible to create a query to see Daily data change rate like you can see on the Azure UI Portal,  I can't find a value/variable to use, thanks.

 

The example fails on my workspace but works ok in the Azure demo

Query data change rate (churn) and upload rate for an Azure VM

See link   (see also screenshot enclosed of error)

Highlighted

@egondalia 

 

I don't seem to be able to open your error file (will try again later); do you have the data it requires?

 

AzureDiagnostics   
| where TimeGenerated > ago(24h)   
| where Category in ("AzureSiteRecoveryProtectedDiskDataChurn", "AzureSiteRecoveryReplicationDataUploadRate")   
| extend CategoryS = case(Category contains "Churn", "DataChurn", Category contains "Upload", "UploadRate", "none")  

 

Do you see all required Columns?

 

Perhaps, try this, and send us the results (if the data is ok to share)?

 

clipboard_image_0.png

 

Highlighted

@Clive Watson 

That's for quick reply, I tried the code you sent and I don't get any output at all, what I am trying to output is the value of disk change that you can see in the "Azure Recovery Vault" were it lists all the replicated items, it shows :

Name >> Rep. Health >> Status >> Rep.Policy >> RPO >> Daily data change rate >> IP >> Rep Errors

 

I am trying to output the "Daily data change rate" but cannot find a way to do this?

 

So far I have the below which works ok, but missing the "data change rate" info

 

AzureDiagnostics
| where replicationProviderName_s == "InMageAzureV2"
| where TimeGenerated > ago(24h)
| where isnotempty(name_s) and isnotnull(name_s) and isnotnull(replicationHealth_s)
| project VMName = name_s , Replication_Health = replicationHealth_s, Status = protectionState_s , RPO_in_Minutes = rpoInSeconds_d / 60 * 1h , RPO = lastRpoCalculatedTime_t , Health_Errors = healthErrors_s , policyName_s 
 
Really appreciate your help on this, thank in advance. :)

 

 

 

 

Highlighted

@egondalia 

 

Sorry I don't have a lot of ASR data, and nothing in that last query looks like an integer we can use to work out data change/ rate/ churn etc...