09 May 2022 08:04 PM - edited 09 May 2022 08:33 PM
All,
I need to export user experience score data per application. I need to only pull applications for a particular management zone. We also have a custom tag on these applications that I could also use as a key if it's available to query.
However, I do not see a parameter I can use in my query. In order to export to JSON I am using a CURL command, so I cannot use the Filter via the UI for Management zone.
Let's say the Management Zone is "NA" for North America. How can I add that to the query?
Here's my query:
select count(*), useraction.application,userExperienceScore FROM usersession group by useraction.application,userExperienceScore order by useraction.application ASC
Thanks!
John
Solved! Go to Solution.
04 Jun 2022 03:54 AM
So I recommend doing an API pull for that and not use the USQL. Environment API v2: