You are viewing limited content. For full access, please sign in.

Question

Question

Querying LFDS database for user last log in in Forms

asked on November 28, 2018 Show version history

I'm working with a client that is attempting to find out when users last logged into Laserfiche Forms. From my research, this is not a current feature in Audit Trail or using Forms. The client queried the LFDS database using the following query 

select a.sid, a.name, u.last_login, a.type

from dbo.account_cache a, dbo.user_logins u

where a.sid = u.sid

and type = 3

order by u.last_login desc

 

which pulls up the following results:

The client would like to know what the type column represents in the table and if this is related to being a Forms Participant User. Does anyone have any information regarding this? 

0 0

Replies

replied on November 28, 2018 Show version history

The type there does not mean participant user. You can get the license type information from the user_licenses table, though it's in the form of GUIDs.

If the Forms Participant license is assigned in LFDS, and the users are signing in to Forms using Single-Sign On, then you could try the following query:

select a.sid, a.name, l.type, u.last_login

from dbo.account_cache a
inner join dbo.user_licenses l on a.sid = l.sid
inner join dbo.user_logins u on a.sid = u.sid

where l.type = 'dde75261-70e3-49f5-84bc-d8ef36f1aa56'

Note that if you have subscription Participant users, this is not the right GUID. It is unique per master license.

 

You can find the right license type ID for your system by querying for a specific user that you know has this type of license:

select a.sid, a.name, l.type

from dbo.account_cache a
inner join dbo.user_licenses l on a.sid = l.sid

where a.name = 'ReplaceWithUsername'

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.