I'm using spotfire version 7.6 and I would like to create a report that would count the number of times my report is opened. Any idea on the best way to create this report?
ID1 column keeps changing for every user so using that column to derive the statistics you need would not be reliable.
Try using the below queries to find out the number of times a report was loaded and by which user on the -
select * from actionlog where log_action ='load_content' and arg1='dxp'
select * from actionlog where log_action in ('load','clone') and arg1='analysisdxp'
load - when loading a non cached report
clone - when loading a cached (scheduled) report
Enabling the "web service" in "User Action Log" resolved the missing the entries in actionlog table. I can use the provided queries now.
Thanks Peter McKinnis and Sayali Patil!
Do you have the Action Log Web Service Enabled? In the "User Action Log" Configuration in the Spotfire Server Configuration Tool, make sure the third radio button "Enable web service" is set to "Yes." If this is not set to yes, then only actions that touch Spotfire Server will be recorded. If this is not enabled, you will need to enable it, restart Spotfire Server(s) and restart the Node Managers. One needs to restart the node manager in order to get the information that the user action web service is up and running.
The actionlog table should have categories for the Web Player, e.g. "library_wp".
I tried both but it's not working because I tried opening a specific report yesterday at least 6 different times and none were included in the result of the query.
Is it possible that actionlog has a bug or I need to configure something in the logger configuration?
Regarding the logger configuration, currently, "Enabled Categories" is set to "All" so I'm assuming that everything should be logged. Though I'm able to see some data for the past months so I think my configuration is okay.
In addition, my report is being cached every hour, is it possible that it causes the missing entries in actionlog? I can see entries coming from the scheduler user but I can't find an entry from my user.
I tried using the "Library_Load_Content" view but I can't see my entries yesterday when I opened my report 6 times. Is it possible that there is a bug in actionlog? Or any idea why there's no log when I opened the report yesterday?
By the way, I only opened the report then closed it at least after 15 minutes. I did not click on anything. I simply opened it.
In addition, my report is being cached every hour so I'm not sure if it has something to do with the missing entries in actionlog.
The user action logs come with a Spotfire analysis file and metadata model as a Library export. You could import the Library export, update the data source and then look at the created Spotfire Analysis file. There are also quite a few views in the Action Logs database that help hid the ambiguity of some of the fields.
For the library -> load_content, the "id2" column has the analysis path so you don't have to use the Id. You could use the Library_Load_Content view which has nicer names for all the library content.
I have the action logs enabled. I can see logs related to the report by filtering category by "library" and filtering action by "load_content". My problem now is that there's only one record in the action log that contains a valid library id via ID1 column while the rest are invalid values I assume since I can't find a match in LIB_ITEMS table. So based on this, it seems that I cannot trust that everything is logged correctly in action log table. Are there other ways to come up with the report I need?