'Recent' Dashboards? Where does the system store which dashboards are used recently?

[Jacob Heubner]

Greetings - 

I'm trying to figure out where something is being stored, and it's driving me a little crazy.

I know the user preferences track the LAST dashboard a user has seen in the 'com.snc.pa.ui.preferences_dashboards' property, but somewhere, it must be storing the recent dashboard(s) a user has viewed.  If you open https://instance-name.service-now.com/$pa_dashboards_overview.do?, there's a 'Recent' selection that shows up to 9 dashboards a user has recently viewed, and, when viewing any specific dashboard, there's a 'Recent' dropdown to show those same selections.

Similarly, I know the report_stats table can show you the last time a report was run, but we're looking to see how often particular dashboards are used and who is using them.  Anyone have ideas on how the system is tracking this information, or how we'd set about leveraging it? 

[Community Alums]

Hi @Jacob Heubner ,

The Dashboards Overview enables you to show dashboards in one of these categories. By default, the Recent category is selected when you visit the Dashboards Overview.

• Recent shows up to nine dashboards that you have visited recently. The most recent are shown first.

Check this table:

pa_dashboards_permissions

[Joe S1 · Accepted solution]

Hi Jacob,

This was a good one. I, like you, assumed it was a user preference somewhere but apparently it's not. The data is coming in from the Navigator Histories table (sys_ui_navigator_history) where the Title is listed as Dashboard.

[Jacob Heubner]

Nice.  Ugly (because it's not easily reportable) but I can build something off this.  Create some kind of view and function to pull out the sys_id from position 35 on the URL and join that to the dashboards to see how often particular dashboards are getting used.

[Joe S1]

That's a good idea for reporting. Nice!