topic Re: Excel Report (ArcGIS Monitor 2023 version) - Service request received counts in ArcGIS Monitor Questions

Excel Report (ArcGIS Monitor 2023 version) - Service request received counts

FraserHand — Mon, 20 Nov 2023 18:20:25 GMT

Morning,

I have a quick question around the Excel Report addin (arcgis-monitor-excel-report-20230825.1) and have a config that looks like this:

report": {
"out_dir":".....t",
"collection": "Excel Report",
"timezone":"Pacific/Auckland",
"end_time": {"now": true,
"year":2021, "month":10, "day":4, "hour":19} ,
"past_days":7,
"past_hours":0,
"types":["host", "storage","arcgis_portal", "arcgis_server", "service", "database" ] ,
"metrics":{
"alerting_on_only":false,
"include_only":[],
"exclude_metrics":[]
}

based on the sample config. When running the report and looking at the svcReqReceived worksheet I'm expecting the count column numbers to be a lot higher for some of our busier services - when comparing to the ArcGIS Server statistics from Manager the numbers don't match. When looking for how many requests a service is getting am I looking in the right place?

Many thanks

Fraser

Re: Excel Report (ArcGIS Monitor 2023 version) - Service request received counts

AndrewSakowicz — Tue, 21 Nov 2023 17:22:54 GMT

@FraserHand The count column shows the number of collected data points, not sum of request values. The one that you want to compare to is the sum, see below

Also, please install the latest Excel Report. It corrects sum vs. avg when aggregating data. Note, currently 2023.2 chart UI only uses avg when aggregating data. This is an open issue that will be addressed later.

Re: Excel Report (ArcGIS Monitor 2023 version) - Service request received counts

FraserHand — Thu, 23 Nov 2023 19:35:41 GMT

Thanks Andrew - I updated the Excel Report and now seeing sums as expected.