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

Analytics config to see all users grouped by business application

thesvg
Regular Contributor
Regular Contributor

I'm looking to develop a report that shows all users grouped by business application. Business application is defined with some type of code and it is stored on Entitlement's custompropertyX for example. Do you have any insights or suggestions on how I could go about creating this report? Thank you.

6 REPLIES 6

rushikeshvartak
All-Star
All-Star

Please elaborate requirement with example.

Do you mean entitlement custompropertyX stored with user group name ?


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

Entitlement custompropertyX is stored with the business application name, so I would like a report that shows all users grouped by each business application. Does that help?

Raghu
Honored Contributor
Honored Contributor

@thesvg  want users groupby based on B-application?  or which User Group have in entiltment cpx ?

 


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

thesvg
Regular Contributor
Regular Contributor

All users grouped by business applications

    1. Business application (ID/Name) is defined with entitlement's custompropertyX

Raghu
Honored Contributor
Honored Contributor

@thesvg  Please modify based on your requirment below query will retun based cpx value user will retun

 

SELECT
U.USERNAME,
A.NAME,
A.ACCOUNTID,
E.CUSTOMPROPERTY1,
COUNT(E.ENTITLEMENT_VALUE) AS EntitlementCount,
MAX(ET.ENTITLEMENTNAME) AS MaxEntitlementName
FROM
ENTITLEMENT_VALUES E
JOIN ENTITLEMENT_TYPES ET ON ET.ENTITLEMENTTYPEKEY = E.ENTITLEMENTTYPEKEY
JOIN ACCOUNT_ENTITLEMENTS1 AE ON E.ENTITLEMENT_VALUEKEY = AE.ENTITLEMENT_VALUEKEY
JOIN ACCOUNTS A ON AE.ACCOUNTKEY = A.ACCOUNTKEY
JOIN USER_ACCOUNTS UA ON A.ACCOUNTKEY = UA.ACCOUNTKEY
JOIN USERS U ON UA.USERKEY = U.USERKEY
JOIN ENDPOINTS EP ON A.ENDPOINTKEY = EP.ENDPOINTKEY
WHERE
EP.ENDPOINTNAME = 'xxxx' AND
E.CUSTOMPROPERTY1 IN ('ADMIN (TSG Only)','ORACLE COLLECTIONS','ORACLE CONFIGURATOR') GROUP BY
U.USERNAME,
A.NAME,
A.ACCOUNTID,
E.CUSTOMPROPERTY1


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

Share sample example with data 


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