Jump to content

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

Akansha Jajodia

Recommended Posts

  • 6 months later...
  • 1 month later...

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,


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...