How to fetch Last login details of any user in Tibco Spotfire

How to fetch Last login details of any user in Tibco Spotfire

book

Article ID: KB0081380

calendar_today

Updated On:

Products Versions
Spotfire Analyst 6.5 and higher

Description

This article talks about how to fetch Last Login details of any user in Tibco Spotfire.

Issue/Introduction

How to fetch Last Login details for any user in Tibco Spotfire.

Environment

All Supported Operating Systems

Resolution

There are two ways to gather this information.

OPTION 1). Query Users table in Spotfire Database

SELECT [USER_NAME]  ,[LAST_LOGIN]
  FROM [Spotfire_server_DB].[dbo].[USERS] (Query for MSSQL Database)

OPTION 2). From Action log database

Prerequisite : Need to install Action logging.

Use the following query to get the last login of users ( Query for MSSQL Database).

  select t.user_name, t.LOGGED_TIME 
from [sf_actionlog].[dbo].[ACTIONLOG] t
inner join (
    select user_name, max(LOGGED_TIME) as MaxDate
    from [sf_actionlog].[dbo].[ACTIONLOG]
	WHERE        (LOG_CATEGORY = 'auth') AND (LOG_ACTION = 'login')
    group by user_name
) tm on t.user_name = tm.user_name and t.LOGGED_TIME = tm.MaxDate

Additional Information

https://docs.tibco.com/pub/spotfire_server/7.0.0/doc/pdf/TIB_sfire_server_7.0.0_installation.pdf
Refer to Section 7 entitled, "Action Logs and System Monitoring​" from the above manual.

https://docs.tibco.com/pub/spotfire_server/7.12.0/doc/html/TIB_sfire_server_tsas_admin_help/GUID-6083CDAB-E023-4144-A65E-3559706FBA3A.html
Powered by Wolken Software