cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Usersession values by country

mcordent
Newcomer

Hi all,


Im trying to show several usersession values grouped by country. I use next query to see values of one country:


select * from usersession where useraction.name like "loading of page /ewavweb/es/entrypoint.do"

where "es" refers to a country (Spain in this case).

I would like to show a chart with values for every country.

I could group by country for example:

select * from usersession where useraction.name like "loading of page /ewavweb/??/entrypoint.do" group by country,

but it is not possible because Dynatrace doesnt provide session country value ( when I do select * from usersession, country value is always null)

Does anybody know how to solve this issue?

Thanks


3 REPLIES 3

ChadTurner
DynaMight Guru
DynaMight Guru

If im following this issue correctly, it appears I am able to do this without issue.


can you share your string that your using?

-Chad

Hi Chad,


I get:



When I do select * from usersession I get null value in country column


Thanks

You might want to open a support ticket then, maybe a configuration step was missed. Have you defined IP ranges and such?

-Chad