Product: TIBCO Spotfire®
How to list all of the users who has accessed a particular report from Spotfire library?
Spotfire "action logs" collects information about the user activity. From the action log, we can also know which user has accessed a particular report from library.
Execute the following query on Action logging database:
---------------------------
Select distinct user_name from [dbo].[ACTIONLOG] where [LOG_CATEGORY]= 'library' AND [LOG_ACTION]='load_content' AND ID2 like '%[Library path of the report]%'
----------------------------
Here is an example:
Select distinct user_name from [dbo].[ACTIONLOG] where [LOG_CATEGORY]= 'library' AND [LOG_ACTION]='load_content' AND ID2 like '%/testfolder/testreport%'
Note: The preceding '\' in the path (right before the 'testfolder' in the above example) indicates the root library folder.
Note: The above query was tested on MSSQL Server Spotfire action log database.
https://docs.tibco.com/pub/spotfire_server/7.14.0/doc/html/TIB_sfire_server_tsas_admin_help/GUID-EC5DB4C9-1528-43D8-9D1B-E3D0EC39164C.html
https://docs.tibco.com/pub/spotfire_server/7.14.0/doc/html/TIB_sfire_server_tsas_admin_help/GUID-67B1DBFC-B1DB-49B1-A492-4B684FAADB72.html
Comments
0 comments
Article is closed for comments.