Solved

FSM: Users logged in log

  • 2 November 2021
  • 6 replies
  • 206 views

Badge +2

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

icon

Best answer by emil.isaksson 4 November 2021, 08:58

View original

6 replies

Userlevel 5
Badge +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! :)

Userlevel 6
Badge +26

@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!

Badge +3

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 

 

 

Userlevel 3
Badge +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

Badge +2

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

Userlevel 5
Badge +13

@Razan Hamedeh ,

No worries bro! Happy to help.Cheers! 😊

Reply