How to trace user login/logout history in MicroStrategy developer 10.x?
Follow the steps below to trace user login/logout history in Strategy Developer 10.x:
Create a database instance for statistics repository in Strategy Developer 10.x. Refer to the following Technical Note for more information on how to create a Database Instance.
Create statistics tables for statistics repository using Configuration Wizard. Refer to the following Technical Note for more information on how to create Statistics Tables.
Open Project Configuration of the project that needs to be monitored, go to Database instances > Statistics, select the Statistics database instance, as shown below:
Go to Statistics > General, select the option Basic Statistics, as shown below (select the specific options under Advanced Statistics Collections Options based on actual needs):
After some user login/logout operations, use DB Query Tool to connect to the statistics database. (DB Query Tool is located at Start > Programs > Strategy > Tools by default installation).
Run the command below in DB Query Tool:
Sample Code/Error SELECT * FROM IS_PROJ_SESS_STATS;
Target the detailed info in the results. Below is an example:
