Skip to main content
Solved

FSM: Users logged in log

  • November 2, 2021
  • 6 replies
  • 255 views
R
Do Gooder
Forum|alt.badge.img+2

How to get all the users (Persons) login activity in FSM? (Ex. Log in time, log out time, changes made by the person...)

Best answer by emil.isaksson

Hi @Razan Hamedeh, 

 

Have you seen the table called PERSON_LOGIN_HISTORY? Seems like that can be what you are looking for. 

But regarding changes done by a user, what changes do you want to keep track of? 

 

Regards,

Emil Isaksson 

 

 

    Charith Fernando
    A

    6 replies

    Charith Fernando
    Hero (Employee)
    Forum|alt.badge.img+13

    Hi @Razan Hamedeh,

    I think you could use ‘Audit’ Screen in FSM to serve your purpose.

     

    Hope you could give columns that you need to audit after selecting the table as ‘person’.



    Hope this helps. Cheers! :)

    -Charith Fernando
    K
    Atheeq Maharoof
    Shneor Cheshin
    Superhero (Employee)
    Forum|alt.badge.img+28
    • Shneor Cheshin
    • Superhero (Employee)
    • November 4, 2021

    @Charith Fernando 

    After setting the audit.

    What table is created/utilised? As I cannot see ‘audit_person%’ table created.

    Or how can I see the sudit?

    Cheers!

    E
    Do Gooder (Employee)
    Forum|alt.badge.img+3
    • emil.isaksson
    • Do Gooder (Employee)
    • Answer
    • November 4, 2021

    Hi @Razan Hamedeh, 

     

    Have you seen the table called PERSON_LOGIN_HISTORY? Seems like that can be what you are looking for. 

    But regarding changes done by a user, what changes do you want to keep track of? 

     

    Regards,

    Emil Isaksson 

     

     

    K
    Sidekick (Employee)
    Forum|alt.badge.img+7

    Hi @Razan Hamedeh ,

     

    As Charith has specified, you can use the Audit screen to configure audit capture for a specific table according to specified constraints.

    After creating the Audit you will need to Refresh cache. 

    Then, once you make the changes on the TABLE.COLUMN,  you can find the corresponding Audit entry in the metrix_audit table in the database.

     

    Best regards,

    Kulunu

    Ann Degroat
    Atheeq Maharoof
    R
    R
    Do Gooder
    Forum|alt.badge.img+2
    • Razan Hamedeh
    • Author
    • Do Gooder
    • November 4, 2021

    Hi @emil.isaksson,

    Thanks! This is what I was searching for regarding the person login history, as for tracking changes, I think Audit screen shall serve the purpose, thanks @Charith Fernando :relaxed:

     

    Regards,

    Razan

    Charith Fernando
    Charith Fernando
    Hero (Employee)
    Forum|alt.badge.img+13

    @Razan Hamedeh ,

    No worries bro! Happy to help.Cheers! 😊

    -Charith Fernando
    Terms & ConditionsCookie settingsAccessibility statement