Usersession values by country

[mcordent]

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

[ChadTurner]

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

can you share your string that your using?

[mcordent]

Hi Chad,

I get:

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

Thanks

[ChadTurner]

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