Fetch login history to data pool

Yes you definitely can there, all you need to do is create an API connection between Audit Log API and Celonis EMS

Please find more information in the below link

https://docs.celonis.com/en/audit-log-api--celonis-ems-connection.html

Hey Kalpeshnath,

Did you check the user adoption views under admin & settings? I think this is just what you need.

I hope it helps!

I was looking for this solution already for a long time, thanks for sharing!

Hi Abhishek,

thanks for the input.

believe this is for audit log not for user login history.

anything similar for user login history?

Hi Balazs - This is what i am looking for but as data pool so I can transform and extend this info to my business users instead limited to admins.

Hi Kalpeshnath,

You can get the data through Studio Tracking Service, kindly find attached link for more information

https://docs.celonis.com/en/studio-tracking-service.html

Unfortunately, currently the only option is to go with the CSV i.e. go to data integration and upload the CSV to create a data model and subsequent Studio view

I will need to double check, but I think in the audit log is included the login event. At least that's the usual in other products.

Hi Kalpeshnath,

Login history is possible.

use python/MLWB using below code to write the login history.

# Get login attempts ---> Needs login enabled in UI in team settings

with open('loginhistory.csv', 'wb') as f:

      downloadFile("api/authentication-events/csv", f, api_key, team_url)

Hi Muthappan, I am not able to to fetch Login history to data pool, could you give me more info if possible?

How are you trying to access Login history? from Machine learning workbench? If so use the below code.

with open('loginhistory.csv', 'wb') as f:

      downloadFile("api/authentication-events/csv", f, api_key, team_url)

pass api_key, team url

def downloadFile(endpoint, fileHandle, api_key, team_url):

  '''Function to query API and download file'''

  url = '{}{}'.format(team_url, endpoint)

  headers = {'Authorization': 'AppKey {}'.format(api_key)}   

  r = requests.get(url, headers = headers, stream = True)

  fileHandle.write(r.content)

then you will have login history in csv format, read it using pandas into dataframe

# Login data

login_df =pd.read_csv('loginhistory.csv')

Find datapool

# Find Data Pool

data_pool = celonis.pools.find(data_pool_id)

data_pool

Push the data to the data pool

data_pool.push_table(table_name="Login_History",

            df_or_path=login_df,

            if_exists="replace")

Perfect Muthappan, everything's working fine, thanks. Eventually, is there a similar solution for the Users (Admin & Settings > Users)? Thank you again

Hi Emanuele,

Not sure if this is possible as an CSV directly, but Celonis allows you to export users and groups via the SCIM protocol, which is accessible as API endpoint.

See the full documentation in the swagger:

Swagger UI (celonis.cloud)

Hi Jan-peter van der Steege, thanks for the reply. I have used the SCIM protocol to get groups and users, but I'm not able to retrieve the information about the "status" show in the image.In particular, the goal is to highlight the users which have no yet accepted the invite to join Celonis. Thanks again

Hi Emanuele,

This should be possible using the 'Get Users' request of the SCIM API. See the result of our demo environment in Postman below:

Kind regards,

Jan-peter

Hi Jan-peter van der Steege, thanks for the reply. For a few days, using SCIM API the access to the Users is now denied. Is it for you too? It's a weird issue, it was working fine before, I did'nt change anything

Hi Emanuele,

For our environment the response is still the same as depicted above. Is it only for the users, or also for other endpoints? The only thing I could think if is the SCIM settings at the Admin & Settings panel..

Regards,

Jan-peter