In the previous version of ArcGIS Monitor (10.8) there was a Usage Reports section where you could get a table of the services used during a time range with columns for Service Type, Source, Total Requests, Average response time, and the number of responses in a series of time ranges; 0-1 sec, 2-3 sec, 4-5 sec, ... 31+ sec. You could select a time range and get summaries for all of the services used during that period. I would like a way to do that in the current version (2025.x)
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
I would like to be able to create a summary table and choose any metrics available for the services, similar to the way that I can set up a Serial Chart by selecting statistics fields and statistics types from a Dataview, then see the results over a selected time range. I would like to see it in tabular form, without a limit on the number of rows. Thanks.
