How to check user log in information via the Statistica meta database when using Statistica Enterprise?

book

Article ID: KB0071134

calendar_today

Updated On:

Products Versions
Spotfire Statistica 14.1 and higher

Description

How to check user log in/log out information via the Statistica meta database when using Statistica Enterprise?

Environment

OS: Windows Only applies to installs which include Statistica Enterprise

Resolution


1. Create the Data Configuration via Statistica Enterprise with a query to pull the desired data.  Please see this example on how to create a Data Configuration (the Data Connection will be the Enterprise Meta Database):  https://docs.tibco.com/pub/stat/14.1.0/doc/html/UserGuide/Default.htm#1-data-mining/example-4-setting-up-a-data-configuration.htm?Highlight=data%20configuration The query is below:
 
SQL Server query:
 
SELECT Name,VFLG as Enabled,Max(TSTAMP) as LastLogin
FROM [CSUSER],CSLOG
WHERE CSUSER.USERID = CSLOG.USERID and CSLOG.ACTN= 'log on' and CSLOG.TSTAMP between DATEADD (YEAR,-3,DATEFROMPARTS(YEAR(GETDATE()), 1, 1)) and GETDATE() 
Group By Name,VFLG 
 
The Oracle equivalent is :
SELECT Name, VFLG as Enabled, MAX(TSTAMP) as LastLogin
FROM CSUSER, CSLOG
WHERE CSUSER.USERID = CSLOG.USERID
  AND CSLOG.ACTN = 'log on'
  AND CSLOG.TSTAMP BETWEEN ADD_MONTHS(TRUNC(SYSDATE, 'YYYY'), -36) AND SYSDATE
GROUP BY Name, VFLG
 
The following Data Configuration in Statistica Enterprise Manager:
 
image.png




2. Bring that data into Statistica workspace by creating and running a workspace using the Enterprise Data Configuration node:

image.png



Note:  This workspace can be used in a Spotfire DXP as a data function.  The DXP can be saved to Spotfire Library and scheduled to run on the Spotfire server to fetch the results in the form of a data table.  



Issue/Introduction

How to check user log in/log out information via the Statistica meta database when using Statistica Enterprise?

Additional Information

Powered by Wolken Software