How do I tell who’s currently logged in?
Comments
-
[font=Calibri, sans-serif]How do I tell who’s currently logged into Decisions? There doesnt seem to be any way to track which accounts are active.[/font]
-
ou can get a good idea of which accounts are currently active in Decisions by querying the [b]entity_account_session[/b] table like so:
select distinct account_id, created_date, expire_date, ip_address, *
from entity_account_session
where expire_date > getdate()
order by last_update_date descThis can also be used as a base for a stored procedure or stored query and used in a report data source flow to power a report. This table stores information about sessions, so there may be more than one row per account. In this case, accounts with multiple sessions can be sorted through for the most recent information to better represent their current login status.
Howdy, Stranger!
Categories
- 4.1K All Categories
- 61 General
- 11 Training
- 201 Installation / Setup
- 1.1K Flows
- 106 Rules
- 260 Administration
- 212 Portal
- 489 General Q & A
- 693 Forms
- 333 Reports
- 3 Designer Extensions
- 47 Example Flows
- 51 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 178 Pages
- 5 Process Mining
- New Features
- 178 Datastructures
- 69 Repository
- 219 Integrations
- 28 Multi-Tenant
- 27 SDK
- 76 Modules
- 56 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 66 Lunch And Learn Questions