I need to do some consolidation on my company's Azure estate, especially around App Service Plans.
In the past, we would typically create a new App Service Plan for each service we deployed as this would aid us with departmental cross-charging as each ASP would be tagged with each department's cost code.
We now have a massive sprawl of ASPs and I suspect none of them are probably running anywhere near capacity, even at S1 level so we're now looking to a more simplified model. We probably also have over-scaled ASPs that we planned but are never actually needed.
Not ever having used Graph Explorer (in anger) can someone please point me in the right direction on where I can find the CPU% instrument data so that I can execute a query to pull this data out.
I know you can "share -> download" from each individual ASP but with the amount of ASPs we have, doing that manually would take forever to do
Once I have that data locally, I can then some basic "what-if" scenarios on around consolidating ASPs and get more cost efficient with our Azure spending.