The dashboard menu now displays dashboard activity, under actions:
How can I access this data to make other visualizations?
For example, I would like to make a table showing how many views each dashboard has had in the last time period.
I believe this information is stored in the Kibana internal index which is something like .kibana_usage_counters. Keep in mind though that this index is internal and not documented. You may have to explore own your own.
I have poked around my indices and used different index patterns in ES|QL to find this data but it appears to be hidden (I am superuser in my space).
Curiously, the AI Assistant was able to generate a list of dashboards with their respective view counts with the following query:
FROM .kibana*
| WHERE url.url LIKE "*dashboards*" AND url.accessCount IS NOT NULL
| STATS total_views = SUM(url.accessCount), last_accessed = MAX(url.accessDate) BY url.url
| SORT total_views DESC
But I am only able to see the results in the AI Assistant UI.
If I paste the same query into Discover I get no results.
The data is juuust out of reach.
Hello @ArielC
I was able to execute below query & get output :
Index name is : .kibana_usage_counters_*
FROM .kibana_usage_counters_*
| WHERE `usage-counter`.domainId == "dashboard"
AND `usage-counter`.counterType == "viewed"
| STATS total_views = SUM(`usage-counter`.count)
BY `usage-counter`.counterName
| SORT total_views DESC
But yes in this table we see the ID instead of the Dashboard name for which we may need to use JOIN or have a list of dashboard map to ID.
Thanks!!