SSO and External Login attempts

[amtg]

Hi,

I want to store the details of the user logging into my servicenow instance. Capturing success and failure of all login attempts the login attempt should include SAML and side_door access.

Could anyone let me know if this information is stored in some table in servicenow already? I want below information to be captured :

• User ID
• User Name
• Login Time

Can you tell me what needs to be done for this?

[Shishir Srivast]

I believe this table might help you: v_user_session, Please navigate to Filter navigation on left side and type v_user_session.list

[amtg]

Hi Shishir,

This table does not provide information if he used a SSO Login or side_door access. Where or How can i get this information?

[Shishir Srivast]

Please check if this helps: External Authentication (Single Sign-On - SSO) - ServiceNow Wiki

Every single sign-on integration creates the following events for login activities, please check in event logs.

[sergiu_panaite]

Try sys_user_session table.