Forum Discussion

Copper Contributor

Aug 30, 2018

Perf counter

Hi, How can I get Perf data for the past 24hrs for CPU, Memory, using log analytics so that I can export the data and create CPU chart outside Azure for the past 24hrs.

Azure Log Analytics

azure monitor

Billy York

Iron Contributor

Aug 30, 2018

sorry I forgot, once you're happy with the query and the data you can export the data to CSV as shown in the screen grab. or you can connect PowerBI.

Sunil Bommala

Copper Contributor

Aug 30, 2018

Thx for reply. I am looking for help with the query itself.

let startTimestamp = ago(1d);

Perf

| where ContainerName == "platformservices" and CounterName == "% Processor Time"

'where' operator: Failed to resolve column or scalar expression named 'ContainerName' Support id: 6676cddc-3db3-46ec-bab9-76aeddf5b402

GouravIN
Brass Contributor
Aug 31, 2018
Hi There,

You can only get below things in Perf query as per schema of this query synatx. I am not sure if you can get any custom thing apart from this.

TenantId
Computer
ObjectName
CounterName
InstanceName
CounterValue
TimeGenerated [Central Time (US and Canada)]
SourceSystem
TravisRoberts
MCT
Aug 30, 2018
It looks like it can’t find the field “ContainerName” Make sure the case is correct and ContainerName is part of the Perf Schema.