Forum

This content is now out of date.

Visit Our Community

History of user’s events

Hello,

Can I see somewhere in the YF data base the information about user's events in the system? I need to know when exactly was a latest connection of particular user to YF. Our YF version is 7.1 build 20150922.

Thank you

Best regards,
Tina
Hi Tina,

The 'Event' table holds most of the events related to Yellowfin. You can query this table to see the last time a user has logged in. For example, the following SQL query will return user logins:

[code]SELECT
E.EventId
,E.IpSource
,P.FullName
,E.EventTypeCode
,E.EventCode
,E.GMTDateTime
,E.EventDate
,E.EventData
FROM Event AS E
JOIN Person AS P
ON E.IpSource = P.IpPerson
WHERE E.EventCode = 'LOGIN'[/code]

Is this what you are looking for? Could you give this a shot and see if this is helpful?

Please let us know how it goes.

Kind Regards,

Dustin
Hi Dustin,

This is exactly what I need. Thank you!

With regards,
Tina