'' operator: Failed to resolve table or column or scalar expression named 'Perf' If issue persists

%3CLINGO-SUB%20id%3D%22lingo-sub-2495294%22%20slang%3D%22en-US%22%3E''%20operator%3A%20Failed%20to%20resolve%20table%20or%20column%20or%20scalar%20expression%20named%20'Perf'%20If%20issue%20persists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2495294%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Community%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20run%20the%20following%20query%3A%3C%2FP%3E%3CP%3EPerf%3CBR%20%2F%3E%7C%20where%20CounterName%20%3D%3D%20%22%25%20Processor%20Time%22%20and%20ObjectName%20%3D%3D%20%22Processor%22%20and%20InstanceName%20%3D%3D%20%22_Total%22%3CBR%20%2F%3E%7C%20summarize%20AggregatedValue%20%3D%20avg(CounterValue)%20by%20bin(TimeGenerated%2C%201hr)%2C%20Computer%3CBR%20%2F%3E%7C%20render%20timechart%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20I%20got%3A%3C%2FP%3E%3CDIV%20class%3D%22notification-wrapper%20ng-star-inserted%22%3E%3CDIV%20class%3D%22notification-container%20error%22%3E%3CDIV%20class%3D%22notification-content%22%3E%3CDIV%20class%3D%22notification-message%20ng-star-inserted%22%3E'where'%20operator%3A%20Failed%20to%20resolve%20table%20or%20column%20expression%20named%20'Perf'%20If%20issue%20persists%2C%20please%20open%20a%20support%20ticket.%20Request%20id%3A%203b67cd23-4f8d-4249-88d4-b8cac1b64346%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22container-end%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22container-end%22%3EAny%20ideas%3F%3C%2FDIV%3E%3CDIV%20class%3D%22container-end%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22container-end%22%3ECheers%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2495294%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELog%20Analytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2495837%22%20slang%3D%22en-US%22%3ERe%3A%20''%20operator%3A%20Failed%20to%20resolve%20table%20or%20column%20or%20scalar%20expression%20named%20'Perf'%20If%20issue%20persis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2495837%22%20slang%3D%22en-US%22%3EYou%20have%20to%20enable%20the%20collection%20first%20(these%20are%20billable%20logs).%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Fagents%2Fdata-sources-performance-counters%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Fagents%2Fdata-sources-performance-counters%3C%2FA%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello Community,

 

I tried to run the following query:

Perf
| where CounterName == "% Processor Time" and ObjectName == "Processor" and InstanceName == "_Total"
| summarize AggregatedValue = avg(CounterValue) by bin(TimeGenerated, 1hr), Computer
| render timechart

 

But I got:

'where' operator: Failed to resolve table or column expression named 'Perf' If issue persists, please open a support ticket. Request id: 3b67cd23-4f8d-4249-88d4-b8cac1b64346
 
Any ideas?
 
Cheers
1 Reply