Problem:
How to get list of all Spotfire users.
Solution:
To get a list of all Spotfire users in its user directory, the following two options are available:
OPTION 1:
Use the Spotfire Server configuration command "list-users" to list all Spotfire users:
Example:
C:\spotfire\spotfireserver\14.0.5\tomcat\spotfire-bin> config.bat list-users
OPTION 2:
It is also possible to get a list of all Spotfire users by executing a SQL query on the Spotfire Server 's application database:
select * from USERS
Note that the USERS table has a LAST_LOGIN column, which lists a date of when each user successfully logged into Spotfire. Null value means that user has never logged.