Statistica Named User License Requirements and Migration from Concurrent Licensing.

Statistica Named User License Requirements and Migration from Concurrent Licensing.

book

Article ID: KB0070001

calendar_today

Updated On:

Products Versions
Spotfire Statistica 14.0.0 and Higher

Description

When migrating from concurrent to Named User licensing in Statistica, it’s important to understand which permissions require a Named User license. All users with access to log into Statistica desktop applications (e.g., Statistica Author, Analyst, Modeler, Data Scientist) are counted as Named Users. However, users with only WebStatistica and Data Entry permissions are excluded from this count, as these applications are processor-based and do not require Named User licensing.


Key Points:

  1. Desktop Applications: Named User licenses apply to desktop installations of Statistica (e.g., Statistica Author, Analyst, Modeler, Data Scientist).
  2. Server Applications: WebStatistica, Data entry, and other server applications rely on processor-based licensing, not named user licenses. Users with the below permissions are not counted as named users since they cannot log into the Statistica desktop application.  
    • Web User (WUSR) 
    • Web Viewer (WVWR)
    • Data Entry (DE)
    • Data Entry Admin (EDE)
    • Data Entry Approver (DEAPP)
    • Data Entry Auditor (DEVIEW)
  3. Counting Named Users with Login Permissions: For Statistica Enterprise, any user with USR permission is counted as a Named User.

Issue/Introduction

This article explains the requirements for named user licenses when migrating from concurrent licensing in Statistica. It provides guidance on identifying which permissions require a named user license and includes SQL queries to count active named users based on login activity. Additionally, it briefly mentions that WebStatistica and server applications use processor-based licensing, so they don't require named user licenses.

Environment

Windows Operating System.

Resolution

Administrators can use the following SQL query based on their database system to count active named users who have logged into the Statistica desktop application.

For customers seeking accurate deployment reports, the timeframe can be adjusted (e.g., past year, past 3 years), ensuring that only active users are included in the count.

For SQL Server:

SELECT DISTINCT CSUSGP.USERID
FROM CSUSGP
JOIN CSLOG ON CSUSGP.USERID = CSLOG.USERID
JOIN CSGPRM ON CSUSGP.GROUPID = CSGPRM.GROUPID
WHERE CSGPRM.PERMID = '268435456'
AND CSLOG.TSTAMP BETWEEN '2023-01-01' AND '2023-12-31'  -- Adjust dates here
AND CSUSGP.USERID IN (SELECT USERID FROM CSUSER WHERE VFLG IS NULL);

The Query for Oracle is similar.

This query will return the count of users who have logged into Statistica during the mentioned year, ensuring that only active named users are included in the licensing count. If necessary, the timeframe in the query can be adjusted based on the requirements.

Powered by Wolken Software