How to show all SSO and non-SSO users

Wim2 · ‎10-27-2020

Hi Admins

I am looking for a way to list:

All users using SSO for loggin on to the system.
All users NOT using SSO for loggin on to the system.

Is there a way to get such an overview?

Greets

Wim

Wim2 · ‎10-28-2020

For we are using SAML for SSO login, every user does have a UPN field populated. If this is not the case, the user is logging in with user/password.

So, I did edit the user List latout and added the UPN field to this List view.

Now I can easaly see who is using SSO and who is using username/password.

Greets

Wim

View solution in original post

Ankur Bawiskar · ‎10-27-2020

Hi,

On user table there is SSO Source field

By default SSO source is populated manually with the sys_id of the IDP that the user belongs to.

You can use that to distinguish

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Community Alums · ‎10-27-2020

But that doesn't work to show actual logins does it?

Example, my user account shows my IDP set, but if I use side_door or login.do and log in with a local password - that wouldn't be shown in the reporting.

Ankur Bawiskar · ‎10-27-2020

Hi,

I believe in that case event based approach can be checked

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Ashutosh Munot1 · ‎10-28-2020

Hi,

In Event logs you see that the session was establised and user has logged in. SAML events occurs for the user who uses the SSO.

Thanks,
Ashutosh

Rahul Priyadars · ‎10-28-2020

You can dig the System Logs if SSO debug Flag is enable in Multi Provider SSO property. For users using SSO logs will look like this.

Regards

RP