question

Wai C. avatar image
Wai C. asked ·

The fact that USQL only works on completed Session is only a limitation for now? or would be a limitation for the future as well?

If it would be a limitation for the future as well, I would like to raise a RFE for this so that product team can consider this again.


Best Regards,

Wai Keat

Dynatrace ManagedRUM
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

James K. avatar image
James K. answered ·
Completed sessions are moved to Elasticsearch which is built for the type of tasks USQL queries perform. Live sessions are stored differently since they are being updated still. I can't speak to plans or anything but that would be the reason why the limitation is in place.
Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Dante P. avatar image
Dante P. answered ·

Hey @Alexander S. We have users taht want to dictch Google Analitycs and ask for this possibility, since the dashboard of GA shows a realtime update for user count.

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Alexander S. avatar image
Alexander S. answered ·

There are no plans to allow USQL also for live user sessions.
What would be your use case? Why do you need it for live user sessions?

3 comments Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

@Alexander S. typically just to have live data in dashboards. Some sessions are really long at our customers, thus you won't see the data in dashboards which prevents them to use the USQL results for real-time or near real-time visibility as advertised.


Just imagine a worker at a shop. His/her sessions are typically hours long (well might be split into several sessions depending on the number of actions). Until the session is finished and finalized within Dynatrace it won't be calculated into USQL results. This makes the whole queries to recent data unreliable.

4 Likes 4 · ·

I was trying to know the current number of users accessing the application, so I use USQL to count the number of distinct IP to achieve this.

0 Likes 0 · ·

I also am frustrated by live session data not being present in USQL. I find USQL useful to watch activity, specifically user actions, while troubleshooting things like application rule matching... having to wait hours to see actions I just completed in testing is a big gap, as well as being unpredictable (given that sessions have different lifetimes).

0 Likes 0 · ·

Space Topics

mobile monitoring dotnet synthetic monitoring reports iis chat kubernetes servicenow amazon web services mysql mainframe rest api errors cassandra dashboard oneagent sdk cmc application monitoring openkit smartscape request attributes monitoring developer community user tagging log monitoring services ufo syntheticadvisory activegate ip addresses auto-detection high five award oracle hyperion webserver uem usql iib test automation license web performance monitoring ios news migration management zones index ibm mq web services notifications sso host monitoring knowledge sharing reports browser monitors java hybris sap vmware maintenance window user action naming javascript appmon ai synthetic classic availability tipstricks automation extensions diagnostic tools session replay permissions davis assistant faq documentation problem detection http monitors server easytravel apdex aws-quickstart network docker tags and metadata cloud foundry google cloud platform synthetic monitoring process groups account usability dynatrace saas gui paas openshift key user actions administration user actions postgresql synthetic locations oneagent security Dynatrace Managed user management custom python technologies mongodb openstack user session monitoring continuous delivery citrix configuration alerting NGINX action naming linux nam installation masking error reporting database mission control jmeter recorder apache mobileapp RUM php threshold azure purepath davis scripting agent aix nodejs android