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
- 2.1K All Categories
- 18 General
- 155 Installation / Setup
- 991 Flows
- 86 Rules
- 203 Administration
- 204 Portal
- 433 General Q & A
- 600 Forms
- 282 Reports
- 3 Designer Extensions
- 38 Example Flows
- 32 CSS Examples
- 1 Diagram Tile
- 5 Javascript Controls
- 139 Pages
- 1 Process Mining
- New Features
- 150 Datastructures
- 50 Repository
- 169 Integrations
- 25 Multi-Tenant
- 21 SDK
- 40 Modules
- 38 Settings
- 20 Active Directory
- 12 Version 7
- 34 Version 8