How to get list of all enabled/disabled Spotfire users
Article ID: KB0070959
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | All |
Description
TIBCO Spotfire Server config command "list-users" can be used to get a list of all Spotfire users which are in enabled or disabled state.
Issue/Introduction
How to get list of all enabled/disabled Spotfire users
Environment
All
Resolution
OPTION 1:
Example to get a list of only enabled user(s):
For versions 7.14 and lower:
C:\tibco\tss\7.6.0\tomcat\bin>config list-users -e true -s "*"
For versions 10.x and above:
C:\tibco\tss\10.3.1\tomcat\spotfire-bin>config list-users -e true -s "*"
OPTION 2:
It is also possible to get a list of enabled/disabled Spotfire users by executing a query on the TIBCO Spotfire Server application database.
Example: SELECT * FROM [USERS] where [ENABLED]=0
Disabled users: ENABLED = 0 or false
Enabled users: ENABLED = 1 or true
Example to get a list of only enabled user(s):
For versions 7.14 and lower:
C:\tibco\tss\7.6.0\tomcat\bin>config list-users -e true -s "*"
For versions 10.x and above:
C:\tibco\tss\10.3.1\tomcat\spotfire-bin>config list-users -e true -s "*"
OPTION 2:
It is also possible to get a list of enabled/disabled Spotfire users by executing a query on the TIBCO Spotfire Server application database.
Example: SELECT * FROM [USERS] where [ENABLED]=0
Disabled users: ENABLED = 0 or false
Enabled users: ENABLED = 1 or true
Additional Information
list-users command line interface command, TIBCO Spotfire Server and Environment - Installation and Administration guide
Disabling user accounts, TIBCO Spotfire Server and Environment - Installation and Administration guide
Feedback
Yes
No
Powered by
