How to get a list of deleted users from the Action Log
Article ID: KB0079806
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | 7.5 and higher |
Description
This article describes a way to use the Action Logs to get a list of all database users who have been deleted from Spotfire.
Issue/Introduction
How to get a list of deleted users from the Action Log
Resolution
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.
Here is an example query to retrieve the records with "log_action=remove_principal" from an Action log database:
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.
"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.
Additional Information
Doc: Action logs and system monitoring
Doc: admin actions logged on Spotfire Server
Feedback
Yes
No
Powered by
