This is a public Forum  publicRSS

Topic

    JLFolkman
    Report for Profiles with Single Sign-On
    Topic posted September 14, 2018 by JLFolkmanMaster 
    100 Views, 3 Comments
    Title:
    Report for Profiles with Single Sign-On
    Content:

    Is there a report or is there a way to report on what profiles have Single Sign-On?

    Answer

     

    • Sebastiaan

      I don't believe there is. You might be able to work this out by checking which agents have used SSO and look at the assigned profile and create a report based on which profiles have used SSO. Not 100% accurate as there might be profiles that have SSO enabled but where agents have never used it but that is all I can think of.

      user_trans.login_method

    • Levi D.

      It's oddly not documented and/or doesn't show up like other profile permissions within reporting, however in my experience you can report on this.  The "SSO Login (SAML 2.0)" profile permission is stored in profiles.integ_perms and the permission value is 256.  All the "perm" type fields on profiles can have multiple permissions so it's best to use the bitand function when you are looking at these fields.  If you want a filter to output only SSO profiles then it would be like:

      bitand(profiles.integ_perms, 256) equals 256

      Or you could output all of your profiles and add a column definition like this to see which are SSO enabled or not:

      if(bitand(profiles.integ_perms, 256) = 256, 'Yes', 'No')

    • Sebastiaan

      Great find Levi, thanks! :-)