Run User Analytics

[JFrance]

Hi Saviynt Community,

Is there a way to run analytics over all users to find patterns within their attributes?

Example: running a search to find all users that have the same local office assignment or running a search to find the top sub groups for users to be in

If this is not possible, is it possible to export a csv of all users and a list of their attributes?

Thanks in advance!

[rushikeshvartak]

You can create analytics report and achieve same.

SELECT u.username           AS 'USERNAME',
       u.firstname          AS 'USER FIRST NAME',
       u.lastname           AS 'USER LAST NAME',
       A.NAME               AS 'ACCOUNT NAME',
       CASE
         WHEN A.status = 1 THEN 'Active'
         WHEN A.status = 2 THEN 'Inactive'
         WHEN A.status = 3 THEN 'Decommission Active'
         WHEN A.status = 4 THEN 'Decommission Inactive'
         ELSE A.status
       END                  AS 'ACCOUNT_STATUS',
       ev.entitlement_value AS 'ACCESS',
       ev.displayname       AS 'ACCESS DISPLAYNAME',
       CASE
         WHEN ev.status = 1 THEN 'Active'
         WHEN ev.status = 2 THEN 'Inactive'
         WHEN EV.status = 3 THEN 'Decommission Active'
         WHEN EV.status = 4 THEN 'Decommission Inactive'
       END                  AS 'ACCESS_STATUS'
FROM   accounts A
       LEFT JOIN account_entitlements1 AE1
              ON A.accountkey = AE1.accountkey
       LEFT JOIN entitlement_values EV
              ON AE1.entitlement_valuekey = EV.entitlement_valuekey
       LEFT JOIN entitlement_types ET
              ON EV.entitlementtypekey = ET.entitlementtypekey
       LEFT JOIN user_accounts UA
              ON UA.accountkey = A.accountkey
       LEFT JOIN users U
              ON U.userkey = UA.userkey
       LEFT JOIN endpoints EP
              ON A.endpointkey = EP.endpointkey
       LEFT JOIN securitysystems SS
              ON EP.securitysystemkey = SS.systemkey
WHERE  A.status NOT IN ( 'SUSPENDED FROM IMPORT SERVICE' )