Issue with Network Type and Load Time for Web Application Sessions

Aboud — Thu, 27 Feb 2025 13:13:25 GMT

Hello Community,

I’m reaching out regarding an issue I encountered after following Dynatrace’s recommendation "Solved: Re: Does DT capture the exact network type (ex:3G/4G/wifi) for [web application's] sessions? - Dynatrace Community" to use the navigator.connection.effectiveType JavaScript variable to retrieve network type information for web sessions.

The Issue Now:

I tried running the query and, while it works, it’s not fully accurate. The query I'm using is:

SELECT * FROM usersession

WHERE useraction.application = "Dealers_oneagent"

and useraction.stringProperties.webnetworksession = "2g"

This query should only return sessions where the network type is "2g." However, it is also returning sessions where the network type is "3g." ex) there are 4 sessions of 2g should be returned, however, the first two sessions show as "2g," but when I select the third and fourth session, I see it as "3g."

2g session:

3g session:

What I Noticed:

In the third session which is "3g", different actions show different network types. Some actions are listed as "3g," while others are listed as "2g." I’m confused as to why the session is represented as "2g" when the network type varies across actions.

The Objective:

For your information, the objective of this exercise is to retrieve the load time of the web apps, excluding sessions with "2g" and "3g" network types. When I exclude these, I should be seeing better load times. However, this is not happening.

When I check the load time for just the "2g" network, the values seem misleading, showing a significantly lower load time. I suspect this is due to the incorrect network type being returned, as described earlier.

Query to Retrieve Load Time:

Here’s the query I use to retrieve the load time, in case anyone wants to test it:

SELECT PERCENTILE(useraction.domContentLoadedTime,80) AS "Duration-80%" FROM useraction WHERE useraction.application IN ("my_web_app") AND useraction.stringProperties.webnetworksession = "2g"

Questions:

Has anyone experienced a similar issue where sessions with mixed network types (e.g., "2g" and "3g") show an incorrect overall network type?
Does anyone have any suggestions on how to correct the inaccurate load times when filtering for specific network type ex) "2g" sessions?