How to get the last login details of all users who accessed a specific report?
Article ID: KB0083157
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | All supported versions |
Description
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.
Issue/Introduction
How to get the last login details of all users who accessed a specific report?
Environment
All supported environments.
Resolution
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.
--------------------------------------------------------------
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.
Feedback
Yes
No
Powered by
