16 Jul 2025 08:30 PM
Hello everyone, good afternoon. I'd like to ask if you know if it's possible to query user session information from Grail?
Running the fetch command, I see that user.sessions exists in the suggestions, and I tried to read the information, but it showed a permissions error. I've already created a policy and added that policy to a group where my user is assigned, and now it only shows that there are no records.
This was the error message that was showing me:
"{
"error": {
"message": "NOT_AUTHORIZED_FOR_TABLE",
"details": {
"exceptionType": "DQL-AUTHORIZATION",
"errorType": "NOT_AUTHORIZED_FOR_TABLE",
"errorMessage": "Insufficient permission to access table (user.sessions).",
"arguments": [
"user.sessions"
],
"queryString": "fetch user.sessions\n| filter (useraction.application == \"ONE\" or userevent.application == \"ONE\" or usererror.application == \"ONE\")\n| summarize session_count = count(), by:{user.id}\n| sort session_count desc\n",
"errorMessageFormatSpecifierTypes": [
"GENERAL_MESSAGE"
],
"errorMessageFormat": "Insufficient permission to access table (%1$s).",
"queryId": "471f733c-880d-41c4-9e16-890e1cdcbb0b"
},
"code": 403
}
}"
This is the policy I added
and this is what appears to me now when executing the dql
Has anyone already worked with that information?
Thank you
Solved! Go to Solution.
17 Jul 2025 08:59 AM
@Jorge3229 I think its planned but not yet available for all users unless you signed up for preview
https://docs.dynatrace.com/docs/shortlink/built-in-metrics-on-grail#real-user-monitoring
https://docs.dynatrace.com/docs/whats-new/preview-releases#join-a-preview