Generate dashboard to see how many users have access different dashboards in the library.

[Akansha Jajodia]

I am trying to generate a dashboard to display number of users vs dashboards user accessed. Cant seem to find much in action log table

[Pierre FErrat]

hello, i have the same question. do you have any update on this topic ?

[David Boot-Olazabal]

Hi Akansha, Pierre,

 

Within the scripts/<database>/actionlog subfolder of the Spotfire server installation folder, you can find a .zip file:

When you have created the actionlog database, and activated it in the Configuration Tool, you can import this zip file (copy it for instance in C:\spotfire\spotfireserver\14.0.1\tomcat\application-data\library or C:\tibco\tss\12.0.5\tomcat\application-data\library) from within the Library administration window (from Tools>Library administration) in your local Analyst client.
Once imported, you have to check the connection (add your own password) and perhaps re-create the elements if you used anything other than the default names for the database name and database user.

Once you have done this, you should be able to successfully open the user_actions dashboard that is provided within the imported .zip file:

On the Library tab, you can find the 'Most Frequently Accessed Analysis Files' from the library. Change the 'Color by' from the default 'Log_Action' to 'User_Name' and you can find the number of users per analysis file:

 

Hope this helps in finding the number of users per analysis files from the library.

If you want to cross-check this with the total number of named users, you can use the the command line  interface: https://docs.tibco.com/pub/spotfire_server/14.1.0/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/count_feature_licenses_and_named_user_licenses.html. Once you have those numbers, you can import those quickly into the user_actions dashboard (either as a local file or from the clipboard if you copy the information you see in the command line interface.

The dashboard itself provides more information, which may also be of use (users per Information Link, etc.). Cross-checking with the total number of users, works in the same way as described above.

Kind regards,

David