Metadata Person table Status

Marko shared this question ago

Answered

https://wiki.yellowfinbi.com/display/yfcurrent/Administration+Object+Definitions ->AdministrationPerson

How long does Person needs to stay inactive so that Status change from ACTIVE TO INACTIVE? (time period)

Is it possible to see last active date for each Person?

/41da39583b8bfa001e225502dce85426

The same question

Replies (4)

Eric Hagfors ●

Hi MArko,

Thanks for reaching out. This User status is an admin configuration and not a time status; Setting a user as inactive prevents login and keeps that user from counting toward the license count.

ac84bd1d65804ee806b729e2e1f91f3a

No "last active date" I can see in our audit content package; although you could possibly look in the event and eventarchive tables table for user login actions and line them up with user id to determine a "last login" date / time.

Hope this helps! Let me know if you have any additional questions.

Thanks,

Eric

Reply URL

Marko ●

Hi thank you for this, event table will help,

it seems that Person table also does not have Username->IDs that are given in YF admin console when creating new user, do you know where can I retrieve that?

Reply URL

Eric Hagfors ●

Hi Marko,

You should be able to identify users via the ipclass table.

a611bf38998e258ba4ad6ae43247e5dd

Let me know if you have any additional questions.

Thanks,

Eric

Reply URL

Eric Hagfors ●

Hi Marko,

I'm going to go ahead and mark this question as Answered at this time, feel welcome to reach out in the future.

Thanks,

Eric

Reply URL