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

Community Alums · ‎10-27-2020

Checking SSO is easy, when people log in using SSO an event is triggered called external.authentication.succeeded and parm1 is their userID. At the same time there are login and session.established events.

The only way I can see of checking if people are using local accounts is that only two events are generated, not three - I hope someone else has a more sensible way of checking that.

Community Alums · ‎03-17-2022

I've been looking for this for a long time mate. thanks a lot! All other possiblities do not work in my environment!

Rahul Priyadars · ‎10-27-2020

Look for Source Attribute in User Table generally its set with AD OU Details and if this value is set USER can not login using any local password.

refer below fields for your reference.

Regards

RP

Wim2 · ‎10-27-2020

Strange,

We do use SSO, but the LDAP, Source and SSO Source fieldds are empty.