Creating clarity users with user groups using JIT

Products

• Clarity PPM SaaS

Issue/Introduction

Information on how to structure the SAML message with User Groups so that the SAML assertion succeeds in creating users with the right group. Where in Clarity do we get the user group names?

Reference: 
Sample SAML message suggested in Clarity documentation: Create a Clarity User Based on SAML Request 

Environment

Clarity 16.3.2

Resolution

UserGroups is an optional SAML attribute, and the value would be comma-separated Group IDs and not names. Group ID can be found from the Clarity user properties page or user list. 

SQL query to extract all the Group IDs:

SELECT

g.group_name "group name",

g.group_code "group id"

FROM

cmn_sec_groups_v g

WHERE

g.language_code = 'en'

AND g.group_role_type = 'GROUP';