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.2K All Categories
- 67 General
- 11 Training
- 202 Installation / Setup
- 1.1K Flows
- 106 Rules
- 262 Administration
- 212 Portal
- 490 General Q & A
- 695 Forms
- 333 Reports
- 3 Designer Extensions
- 47 Example Flows
- 52 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 179 Pages
- 5 Process Mining
- New Features
- 179 Datastructures
- 69 Repository
- 221 Integrations
- 28 Multi-Tenant
- 27 SDK
- 78 Modules
- 56 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 83 Lunch And Learn Questions