Date Posted:
Product: TIBCO Spotfire®
Product: TIBCO Spotfire®
Problem:
How to get a list of deleted users from the Action Log
Solution:
This article describes a way to use the Action Logs to get a list of all database users who have been deleted from Spotfire.
When Action Logging is enabled on the TIBCO Spotfire Server and you have deleted the users from Spotfire (via either the Administration Manager tool, the delete-user command, or via the TIBCO Spotfire Configuration Tool user interface), the activity will be recorded in the Action log with the log_action "remove_principal" when database users/groups are deleted. ID1 column would indicate the user name and ID2 column will give the information if it is a user or group.
"remove_principal" is an Admin category action logged on Spotfire Server when you enable Action logging.
Here is an example query to retrieve the records with "log_action=remove_principal" from an Action log database:
select logged_time,user_name,original_time,log_category,log_action,ID1,ID2
from ACTIONLOG
where log_action='remove_principal'
order by logged_time desc
For example:
Disclaimer: The content of this article is for informational purposes only. The subject material may change in any new versions with no notice and there is no responsibility by TIBCO to maintain or support future access to this internal application content. Modification of any internal application content is not recommended and can lead to an unsupported configuration. It is not intended to be used "As Is" in a Production environment. Always test in a Development environment.
Doc: Action logs and system monitoring Doc: admin actions logged on Spotfire Server
Comments
0 comments
Article is closed for comments.