Spotfire: How to get a list of deleted users from the Action Log

How to get a list of deleted users from the Action Log database.

Details:

This article describes a way to use Spotfire Action Log to get a list of all database users who have been deleted from Spotfire.

Solution:

When Action Logging is enabled on Spotfire Server and you have deleted users from Spotfire (via either the Administration Manager tool, the delete-user command, or via the Spotfire Server Configuration Tool user interface), the activity will be recorded in the Action log with the log_action of "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.