Creating Basic Dashboard Report - User Login Sessions by Month
Good Morning,
I am new to Creatio, and trying to create a dashboard for our internal team that shows Creatio Session logins by Organization role and/or User/Contact. What I need to see his now many session login by Month. I know this data exists in the Active User Statistics, but I am having trouble getting the username for these logins.
Would my starting point be the Active Users Statistics object, user, or some other object?
Any help for this newbie would be welcome. Thanks!!
Like
I would use the "User session" object and then group by user. The User session object stores the individual sessions started/ended for a user, you can get to the user from that object as well. The "Active Users Statistics" is only a summary count of sessions, not the sessions by user etc.
Ryan
I would use the "User session" object and then group by user. The User session object stores the individual sessions started/ended for a user, you can get to the user from that object as well. The "Active Users Statistics" is only a summary count of sessions, not the sessions by user etc.
Ryan
Ryan Farley,
Ryan, this worked great. Would you happen to know how to drill into a user record by role (Organization Role). For instance, if I wanted to see how many unique session per month for a particular org role that is assigned to a set of user (Like Sales, IT, etc)? BTW thank you very much for your help.
Greg Sinclair,
Not completely sure you could do that without some dev work. Maybe? Possibly I'm just not thinking through how to organize it. Since a user can have multiple roles and User session is tied to a user. What I would likely do is create a database view to flatten out the data between UserSession and SysAdminUnit (org roles I believe are SysAdminUnitTypeValue of 0 or 1, functional roles 6) with ConnectionType=0 for internal users. Then join between there to UserInRole and then UserSession. Then use that for the dashboard.