How to list all of the users who has accessed a particular report from Spotfire library?
book
Article ID: KB0080157
calendar_today
Updated On:
Products
Versions
Spotfire Server
All Supported Versions
Description
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.
Environment
All Supported Environments
Resolution
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.
Issue/Introduction
How to list all of the users who has accessed a particular report from Spotfire library?