Can Audit Reports include the order of Dashboard tabs per user?

Christine B shared this question 12 days ago
Awaiting Reply

We occasionally push dashboard tabs out to our users. When working with our executives, we'd like to understand exactly what they will see when they login to the Reporting console. In the OOTB audit reports, I can see which dashboards have been added for the users. Is there a way to include the order of the dashboard tabs in the audit reports?

Comments (2)

photo
1

Hi Christine,


Thanks for your question.


I've attached a screenshot to this message. To clarify what you are after, in the example below, you would want to know that the order of the Dashboard is 'Sales Performance' and then 'Campaign Analysis' for my account?


If this is what you are after, this does not currently exist as part of the Audit Content. I may have to ask the Developers to understand how this is order is generated.


Kind regards,

Simon


/963a1348aa672bb2cd8fc6eb66cd9c37

photo
1

Hi Simon. That's exactly what I'm looking for. I figure the data has to exist in the database somewhere, because how else would the dashboard tabs show up in the same order every time right?

Thanks for your assistance.

photo
photo
1

Hi Christine,


Just to touch base with you, I've spoken with my colleagues about your question (based on my previous assumptions) and played around with the Database to understand if there is a way to retrieve this information with no success. It seems that this is generated in the UI programmatically rather than being stored in the Database.


If you wanted to help me understand the reason that you wanted this information/ how you wanted to use this information, I may be able to offer alternatives.


Kind regards,

Simon

photo
1

Hi Simon,

My customer wants to push dashboard to executives in the company. They want to know ahead of time the experience the executive will have when they login. That way they can better answer questions or push different dashboards to the executives.

photo
1

Hi Christine,


Thanks for clarifying that. The way that these Dashboard tabs are generated, is that they are the the most recently 'favourited' Dashboards. Once that order has been initialised, the user is able to move and edit this order the of these tabs based on their preference. If you are pushing a new Dashboard to an exec, it will be the last one on the list of their already existing Dashboard tabs. When you reach the limit of Dashboard tabs that can be shown in the top toolbar, a drop down menu appears where again the most recently added. This might be the only information you need.


A query that may be useful that you can run against the Configuration Database is provided below. It might need some tweaking for your database, and you will need to find the IpId of the person you are intending to find the Dashboard. In the example I've provided, it assumes you know the left part of the email so you can substitute 'admin' with that.


Let me know if this helps at all.


Kind regards,

Simon


select ShortDescription 
from personfavourite pf
join reportgroup rg on pf.ContentId = rg.groupid
where (NavigationClass = 'com.hof.content.navigation.dashboard.DashboardNavigation'
or (createbycode = 'MANUAL' and NavigationClass is null))
and ipperson = (select ipid from ipclass
where emailleft = 'admin')
and statuscode = 'OPEN'
order by sequencenumber; 

photo