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.
https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/monitor-and-scale-database-powershell
The Get-AzMetric reference below also gets the App Service metrics.
https://learn.microsoft.com/en-us/powershell/module/az.monitor/get-azmetric?view=azps-7.4.0
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.