I want to know the kusto query for getting the CPU consumption and memory usages by adf pipelines above threshold

Question

Presently, I am using kusto query language to get the value of CPU consumption and memory utilized above a certain threshold. I have kept the scope as that adf in log analytics workspace. Whenever I run some query I am getting no result, even when the pipeline gives considerable results for these parameters in the metrics section. I have gone through these sources for finding Kusto queries: https://www.cloudsma.com/2018/07/cpu-processes-azure-log-analytics/ https://www.catapultsystems.com/blogs/creating-next-generation-queries-for-cpu-and-memory-kpis-in-log-analytics/ https://pixelrobots.co.uk/2019/06/monitor-your-servers-cpu-usage-using-azure-log-analytics/

And also tried the ones given as the sample queries in log analytics workspace. Besides, on using "Perf" in the queries, an error is thrown stating that "'where' operator: Failed to resolve table or column expression named 'Perf'". How do I get the results using kusto queries?