Reporting using related list

[Tim_D]

Hello,

I have been asked to create a report that seems simple enough:  a list of all Assignment group managers that have NOT visited a specific Dashboard within x amount of time, ie Wall of Shame.

Simple enough, I think.  A report on the sys_user_group table showing names of the mangers of the filtered list of groups.

To see who has NOT visited the dashboard a Related List filter based on sys_ui_navigator_history matching 0 entries.  filtered by the name of the Dashboard.  Or so I think and will play around with that.

The problem is that I can't find sys_ui_navigator_history in the Related List Conditions tables.  

Obviously I am missing something.  I've spent my afternoon looking at related lists, but those documents don't seem to apply.  

Can someone point me in the right direction?  I would greatly appreciate it.

[AndersBGS]

Hi @Tim_D, 

Have you looked at the great article written by @Adam Stout for Tracking and Reporting on Dashboard Usage in ServiceNow. This will ensure that you gain a perfect view of who have viewed which dashboard.

I know this article is not what your asking for, but I do believe that you will gain the benefit and have a resolution to your question.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Tim_D]

Hi @AndersBGS,

I appreciate your response.  I had actually found that article in my searching.  It's great stuff.  But as I read through it it appeared to be a method for creating a new table that would contain information I can currently get to by filtering the sys_ui_navigator_history table.  While it would allow for more elegant and additional usage, it doesn't help with my need.

Perhaps I can better explain the need and that might clarify where I am stuck:

My need is to identify who has NOT visited a specific dashboard.  I think whether I use Adam's method or not, the issue will remain the same. 

How do I list Adam's table (for lack of a better name right now)  or any database view, or the sys_ui_navigator_history table as a related table to the sys_user_group table when creating reports?  This would allow me to report on the Groups table (assignment group manager) where there are no matches to the user that have visited the dashboard.

Thanks again.  I have used a LOT of ideas from @Adam Stout to accomplish the things I need.  And in this case, I can see a future where more info my be requested that would make the full table a plus...  but for now, I have to create a Report of Shame for upper management.

Tim

[AndersBGS · Accepted solution]

Hi @Tim_D ,

Just made some modifications in my PDI according to your requirement based on Adams table.

Based on below view, you can see that admin have accessed the dashboard twice, where abel have not visited it due to that item has never been created on dashboard usage table.

This is done by:

1. implementing Adams table.

2. make a database view linking "dashboard usage"(new table) and sys_user table:

off course, there could be some minor twerks to the overall configuration according to your needs, but I do see that this will work. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Tim_D]

Hi Anders,

Thank you for your help.  I can see that this will do what I need.  I had begun wondering about a database view to accomplish it.  This is a great first step for what I need!

I am always concerned about creating new tables that may have licensing impacts so I may try building a database view between the sys_user or sys_user_group table and the Navigation history table.  This may give me a broader range of reporting opportunities, but I'm a little leery of using the History table in a DB view.

Time to do some playing in my PDI!

Thank you VERY much for the help!

Tim