Metadata Person table Status

Marko shared this question 2 months 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

Comments (4)

photo
1

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

photo
1

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?

photo
1

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

photo
1

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