EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB14494: Is it possible use the MicroStrategy SDK 9.x to get a user’s last login date or time?


Community Admin

• Strategy


There is currently no direct method to obtain a user's last login date or time using the MicroStrategy SDK 9.x.

There is currently no direct method to obtain a user's last login date or time using the Strategy SDK 9.x.
 
One possibility is to have an external source that keeps track of the login date and time stamps. Currently, the only place the last (and previous) login date or time information can be stored out-of-the-box is in the Strategy Intelligence Server 8.x statistics tables. The IS_SESSION_STATS table logs every connection to and every disconnection from the Strategy Intelligence Server, and the IS_PROJ_SESS_STATS records the same for project sessions.
 
Refer to the section 'Enterprise Manager statistics data dictionary' in the Strategy 9.0.x and newer versions of the System Administration Guide for details of tables and the information that is available in them to be queried.
 
No Strategy API call needs to be made, and hence, a custom add-on will need to be written to query the Statistics Database. Refer to the Strategy Developer Library (MSDL) and the Strategy Knowledge Base for information on add-ons.
 


Comment

0 comments

Details

Knowledge Article

Published:

June 23, 2017

Last Updated:

June 23, 2017