How to check user log in information via the Statistica meta database when using Statistica Enterprise?
Article ID: KB0071134
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
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:
2. Bring that data into Statistica workspace by creating and running a workspace using the Enterprise Data Configuration node:
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
For information about only CNET-type installations, see https://support.tibco.com/s/article/How-to-manage-users-using-the-TIBCO-Statistica-application-in-a-CNET-type-only-installation
Feedback
Yes
No
Powered by
