How to get the last login details of all users who accessed a specific report?

How to get the last login details of all users who accessed a specific report?

Spotfire "action logs"  collect information about the user activity. Using the query mentioned in the Resolution section below you can get the last login details of all users who accessed a specific report in Spotfire. Replace the "Report_Name" with the actual report name where the users accessed.
--------------------------------------------------------------

SELECT user_name, MAX(LOGGED_TIME) AS Lastlogin  FROM [dbo].[ACTIONLOG] WHERE (LOG_CATEGORY = 'auth') AND (LOG_ACTION = 'login')

AND user_name IN (SELECT DISTINCT   user_name FROM [dbo].[ACTIONLOG] WHERE ID2 LIKE '%Report_Name%')
GROUP BY user_name

---------------------------------------------------------------
Note that the above query was tested on MS SQL Server Spotfire action log database.