Report required for average response time of a http URL monitored inside a component

Question

Hi All,

Can anyone help me with the report creation for average response time of a http URL monitored inside a component,

as mentioned like below

Application Average Response TimeDATE / TIMEAvg_Response_TimeMinMax_Response_Time13-Sep-181:00 PM107.0 ms54.0 ms338.0 ms13-Sep-183:00 PM103.0 ms49.0 ms328.0 ms13-Sep-185:00 PM172.0 ms49.0 ms1752.0 ms13-Sep-187:00 PM99.0 ms54.0 ms178.0 ms13-Sep-189:00 PM102.0 ms46.0 ms368.0 ms

zackm · Accepted Answer

This is one that can be accomplished in the GUI, no need for custom SQL/SWQL

Go to the Manage Reports section and start building a new report using a 'Custom Table' resource.

Make sure you select "Component" as the object you want to report on; then create whatever type of filter you need to find the component(s) you're interested in:

While selecting your columns, make sure you grab the 'Response Time' metric under the 'Components/Response Time History' section (you'll need 3 copies of this one metric for AVG/MIN/MAX):

Setup your column settings, paying particular attention to the Display Setting, Data Aggregation, and Date/Time Sample Interval sections:

Back on the primary layout builder page, make sure you select the timespan you're interested in as well:

All of this should result in a report similar to this one: