Skip to main content
Solved

JSS dashboard - how to identify troublemakers :)

  • January 11, 2017
  • 4 replies
  • 15 views

donmontalvo
Forum|alt.badge.img+36

We have many techs, and they all love the JSS Dashboard.

Is there a way to tell who is using the JSS Dashboard excessively.

I mean, it is there to be used, but how do we know if someone has 1,000 pie charts in their JSS Dashboard?

Is there any documentation or the Dashboard's impact to JSS?

Asking for a friend.

Best answer by mscottblake

Looks like the only way is via MySQL.

List all dashboard objects:

SELECT * FROM `user_preferences` WHERE `key_pair_name`='dashboard';

Get a list of users and the number of dashboard objects:

SELECT `username`, count(*) FROM `user_preferences` WHERE `key_pair_name`='dashboard' GROUP BY `username`;

4 replies

scottb
Forum|alt.badge.img+18
  • Valued Contributor
  • January 11, 2017

Interesting question.
I wondered about that too.


mscottblake
Forum|alt.badge.img+24
  • Honored Contributor
  • Answer
  • January 12, 2017

Looks like the only way is via MySQL.

List all dashboard objects:

SELECT * FROM `user_preferences` WHERE `key_pair_name`='dashboard';

Get a list of users and the number of dashboard objects:

SELECT `username`, count(*) FROM `user_preferences` WHERE `key_pair_name`='dashboard' GROUP BY `username`;

donmontalvo
Forum|alt.badge.img+36
  • Author
  • Hall of Fame
  • January 30, 2017

(Duplicate)


donmontalvo
Forum|alt.badge.img+36
  • Author
  • Hall of Fame
  • January 30, 2017

@mscottblake thanks, beats my friend's solution.