Hey Roguen Keller, what's up?
To answer your question, there is no direct way to query the DB like you are showing. However, you could probably accomplish the goal through a combination of Jive API calls. You may have to post-process some of the API responses to narrow the results.
The API queries do have some filterability built in that may help with narrowing the search to specific places and date ranges.
I hope you are doing well.
We are actually doing something very similar for a client - looking up unanswered questions in a list of places for a certain date range. Is that close to what you need to do?
Thanks for the quick reply John!
I suspected this was the case. I can also now see that the cloud admin tool does not allow DB downloads for cloud environments. So going that route is also not an option. API access in the manner you share seems to be the only route.
As for the query itself, while your example does match what I have above, this is just an example of one of the queries we would need. I have about 10 different queries aimed at various metrics and checks. These remain mostly static, but change from time to time.
It appears I would need to create these one off for the time being.
Again, If anyone else out there has a more creative plan, I would love to hear it. Marking this answer correct though.