Hi, @badri srinath
You can use the Az-PowerShell module Get-AzMetric to access resource metrics.
Below is a sample getting the SQL Database metrics.
The Get-AzMetric reference below also gets the App Service metrics.
If this doesn't work, please tell me why.
If you can't do it well with this, ask additional questions. We will always help you.