I would like to chart the number of user actions according to a specific URL.
This url looks like: /eWavWeb/util/GetJSAudit.do?function=getJSON. (this is an Ajax call)
When i do select useraction.name from useraction where useraction.name like '*/eWavWeb/util/GetJSAudit.do*',
I only get /eWavWeb/util/GetJSAudit.do as useraction.name.
When I enter in session details. I can see details of the action, Xhr Request:
How can I get the number of request (or useraction) according to /eWavWeb/util/GetJSAudit.do?function=getJSON?
Solved! Go to Solution.
have you tried using aggregate functions?
e.g.,: SELECT useraction.name, count(*) FROM useraction where useraction.name = "/api/products" group by useraction.name