Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

How to get Provisioning Owner details from Endpoints

harishyara
Regular Contributor
Regular Contributor

Hello Team,

Is there any way that we can query to get Provisioning Owner from endpoints ?

Thanks,

Harish

1 REPLY 1

rushikeshvartak
All-Star
All-Star

SELECT CASE ownertype
         WHEN 2 THEN 'User Group'
         ELSE 'User'
       END AS 'Owner Type',
       CASE ownertype
         WHEN 2 THEN (SELECT user_groupname
                      FROM   user_groups
                      WHERE  ownerkey = usergroupkey)
         WHEN 1 THEN (SELECT username
                      FROM   users
                      WHERE  userkey = ownerkey)
         ELSE 'admin'
       END AS 'Owner'
FROM   endpoints 

rushikeshvartak_0-1715012820362.png

 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.