In some scenarios, it may be necessary to get the list of the users who created the sessions by querying against statistics table IS_SESSION_STATS, however the USERID column only logged the GUID of the user who created the session, as shown below:
In order to get the user names, the metadata table DSSMDOBJINFO should also be referred, follow the below steps to get the user names by querying against statistics table IS_SESSION_STATS and metadata table DSSMDOBJINFO:
1. Get the user IDs:
Sql
SELECT * FROM IS_SESSION_STATS
2. Get the user names:
Sql
SELECT * FROM DSSMDOBJINFO WHERE OBJECT_TYPE = 34 and OBJECT_ID='USERID from step 1'
Metadata Modification:
WARNING:
Manually editing values in the Strategy Metadata incorrectly may cause serious, project-wide problems that may make your project unusable. Since these are user-initiated changes, they are not covered by any Strategy warranty. Users are strongly encouraged to backup Metadata prior to any alteration.
