Create a summary table in ArcGIS Monitor

[JustinJ_DTS]

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)

[DerekLaw]

Hi @JustinJ_DTS,

> 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. 

It is possible to create a table showing the top 10 most requested services with the Table element in analysis views. Unfortunately, it is not possible to sum the data or generate any statistics on that data. Sorry. Please submit an enhancement in the ArcGIS Monitor Ideas forum. 

Hope this helps,

[DavidJantz]

@DerekLaw, Could you share how creating such a table is possible? I can't figure out how to display the most requested services in a table without being able to aggregate metric data. 

[DerekLaw]

Hi @DavidJantz,

> Could you share how creating such a table is possible? - showing the top 10 most requested services 

Below is a dataview expression to query for services and the requests received within the last 30 days; it excludes the system services.

 

EDIT: To clarify, the Attribute table will not show metrics over a time range, only the top 10 most requested services. In this case, in the last 30 days (because of the dataview query). Apologies if there was any confusion in my previous post. 

Hope this helps,


 

[DavidJantz]

@DerekLaw I think it's important to clarify that this view produces the top (or bottom) requested services within an X-minute period (the observer defaults to 5 minutes). Maybe you can decipher something about usage spikes or repeat services meaning high sustained usage, but it's really not very helpful.

The only current alternative is a bar graph but then you have to visually compare and inspect each item to see the metric value. 

Link to idea for anyone reading: Usage Reports and Summary Table Idea 

[JustinJ_DTS]

I agree.  That's what I'm seeing as well.  These table rows show the number of requests per service within each observation interval.  You can sort that and see the busiest 5 minute bursts over the date/time filter set in the top corner of the Analysis window, but the summation is lacking.  I would like to see the services with the most request over the previous 7 days, not the service(s) that had the busiest 5 minutes in that time.

In the example from @DerekLaw , I would like to do a "GROUP BY" on the Components Name column, and a "SUM" on the Metrics Data Value column, then see the top rows in descending order over the date/time interval of the Analysis

As Derek requested, I submitted an Idea for this feature on the ArcGIS Monitor project page:

https://community.esri.com/t5/arcgis-monitor-ideas/usage-reports-and-summary-tables/idi-p/1645647

[JustinJ_DTS]

Here is an example from ArcGIS Monitor 10.8.  It's what I would like to create in 2025.x