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.

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.