Hey AJ,

You can find information on which users are logged into Forms with an authenticated participant license through the Forms database.

The steps would be as follows:

1. Log into SQL Server Management Studio or whichever database management tool you use
2. Go to Databases -> Forms -> Tables
3. You'll want to access the dbo.cf_users and dbo.cf_sessions tables

In dbo.cf_users you can find the user_type which corresponds to these different user types. You'll primarily be interested in 3, 4, and 8.

3 = Authenticated participants

4 = LDAP inherited Forms participants

8 = SSO participants

Once you have that information you can look look to their user_id. The user_id will be needed to join the two tables.

Within dbo.cf_sessions you will also user_id, but also the column last_active. Writing a query using the details I have provided should produce what you are asking.

A few things to also note:

• last_active is in UTC
• If they explicitly logout, the dbo.cf_session entry should be removed
• You'll only see the zombie session if their browser is closed without logging out or if the browser crashes

Thanks,

Kevin