Where is the log information for a locked out user in Statistica Document Management System?

Where is the log information for a locked out user in Statistica Document Management System?

book

Article ID: KB0080828

calendar_today

Updated On:

Products Versions
Spotfire Statistica 12.0 and above.

Description

A user has been locked out of SDMS.  Where is this information logged?

 

Environment

Windows operating systems only.

Resolution

In the SDMS database, there is a table called SDMSYSTEMLOG that contains all sorts of logging information.

Below, the operation name, OPNAME, the operating time, OPTIME, and the user id, ID1, is displayed in the SDMSYSTEMLOG table:
SDMSYSTEMLOG


Another table, SDMUSERS, show  if a specific USERNAME is DISABLED:

SDMUSER table

To enable a disabled user, open the SDMS Admin tool, right click on the user (SDMSUser in this case) then select Properties, and then un-check the "Account is disabled" box and click "OK":


SDMS Admin Tool

 

Issue/Introduction

This article discusses where is the log information for a locked out user in SDMS and the details of the information. Additional information about enabling a disabled user account.