OMS query is showing "no Result Found"

%3CLINGO-SUB%20id%3D%22lingo-sub-466484%22%20slang%3D%22en-US%22%3EOMS%20query%20is%20showing%20%22no%20Result%20Found%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-466484%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20deployed%20Storage%20analysis%20solution%20from%20Github%3A%20%22%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FAzure%2Fazure-quickstart-templates%2Ftree%2Fmaster%2Foms-azure-storage-analytics-solution%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FAzure%2Fazure-quickstart-templates%2Ftree%2Fmaster%2Foms-azure-storage-analytics-solution%3C%2FA%3E%22%3C%2FP%3E%3CP%3EWhile%20checking%20the%20storage%20capacity%20chart%20the%20query%20is%20showing%20no%20result.%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20the%20default%26nbsp%3B%20query%20written%20in%20the%20solution%20%3A%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3EAzureStorage_CL%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Ewhere%3C%2FSPAN%3E%3CSPAN%3E%20MetricName_s%20%3D%3D%20%3C%2FSPAN%3E%3CSPAN%3E%22MetricsCapacity%22%3C%2FSPAN%3E%20%3CSPAN%3Eand%3C%2FSPAN%3E%3CSPAN%3E%20TimeGenerated%20%26gt%3B%20ago%3C%2FSPAN%3E%3CSPAN%3E(%3C%2FSPAN%3E%3CSPAN%3E1%3C%2FSPAN%3E%3CSPAN%3Eh%3C%2FSPAN%3E%3CSPAN%3E)%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Esummarize%3C%2FSPAN%3E%3CSPAN%3E%20UsedGB%20%3D%20avg%3C%2FSPAN%3E%3CSPAN%3E(%3C%2FSPAN%3E%3CSPAN%3ECapacity_d%3C%2FSPAN%3E%3CSPAN%3E)%3C%2FSPAN%3E%20%3CSPAN%3Eby%3C%2FSPAN%3E%3CSPAN%3E%20StorageAccount_s%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Esort%3C%2FSPAN%3E%20%3CSPAN%3Eby%3C%2FSPAN%3E%3CSPAN%3E%20UsedGB%20desc%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%2F%2F%20Oql%3A%20Type%3DAzureStorage_CL%20MetricName_s%3DMetricsCapacity%20TimeGenerated%26gt%3BNOW-1HOUR%20%7Cmeasure%20avg(Capacity_d)%20as%20UsedGB%20by%20StorageAccount_s%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-466484%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hi All,

 

I have deployed Storage analysis solution from Github: "https://github.com/Azure/azure-quickstart-templates/tree/master/oms-azure-storage-analytics-solution"

While checking the storage capacity chart the query is showing no result. 

Here is the default  query written in the solution :

AzureStorage_CL
| where MetricName_s == "MetricsCapacity" and TimeGenerated > ago(1h)
| summarize UsedGB = avg(Capacity_d) by StorageAccount_s
| sort by UsedGB desc
// Oql: Type=AzureStorage_CL MetricName_s=MetricsCapacity TimeGenerated>NOW-1HOUR |measure avg(Capacity_d) as UsedGB by StorageAccount_s