Top user actions - UserSession table or UserAction table?

[ABB]

Whether it's the count of frustrated user actions or Top user actions, should we get it from usersession table or useraction table? Need some guidance on this. I see counts vastly differ for both.

In addition, I see another issue- Not sure if this is our company instance, but when I use the user session table, the where clause doesn't work and pulls all the application names, whereas if I use the useraction table, my results are limited to the application name. 

SELECT useraction.application, useraction.name, COUNT(*) FROM usersession WHERE useraction.application ="My_App" AND useraction.apdexCategory="FRUSTRATED" GROUP BY useraction.application,useraction.name

vs

SELECT useraction.application, useraction.name, COUNT(*) FROM useraction WHERE useraction.application ="My_App" AND useraction.apdexCategory="FRUSTRATED" GROUP BY useraction.application, useraction.name

[christian_gusta · Accepted solution]

Hi,

This is explained in the documentation of USQL how the filtering works for primary and secondary "tables" works: https://www.dynatrace.com/support/help/how-to-use-dynatrace/real-user-monitoring/how-to-use-real-use...

[ABB]

Thanks! This explains it!