I am looking for a way to create a table of the "Top 10" most requested services over a selected time range and display the sum of each service's requests over the time range selected in an Analysis view, along with other summary data, if possible.
I imagine I would need to create a Data View, with "Service" as the Component Type, and then join the Metrics to get "requests_received". If I create a Table from that Data View, it will show the number of requests during each interval over the time range selected in the Analysis view. I would like to sum the requests and group by the Service Name.
In pseudo SQL, it would be something like:
SELECT components.name as ServiceName , SUM(metrics_data.value) as Requests
WHERE components.type = 'service'
JOIN metrics_data
GROUP BY ServiceName
ORDER BY Requests DESC
Is anything like this possible with a Table or any other method? In the older version of ArcGIS Monitor (10.8) you could go to the Reports menu and select "ArcGIS Server Reports" or "Usage Reports" to see summary tables for the services over the time range you selected, with the total number of requests and the average response time at different intervals. Some of the managers in my organization want something similar from the current version (2025.0)
