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 query to get the summary of User Manager Campaign

yeddulanaveen
New Contributor
New Contributor

Hi,

We need a query for creating analytics to get the summary of the User Manager Campaign.

Regards,

Naveen

6 REPLIES 6

pmahalle
All-Star
All-Star

@yeddulanaveen ,

Saviynt does provide OOTB option to export summary of User Manager Campaign and even Summary of Certification present in the campaign. 

pmahalle_0-1713184949178.png

OOTB report doesn't fulfill your requirement? 

 


Pandharinath Mahalle(Paddy)
If this reply answered your question, please Accept As Solution to help other who may have a same problem. Give Kudos 🙂

Raghu
Valued Contributor III
Valued Contributor III

@yeddulanaveen  Below article will help full and it have report query details

https://forums.saviynt.com/t5/identity-governance/um-campaign-data-analytics-report/m-p/54339

 


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

rushikeshvartak
All-Star
All-Star

Is there any limitation you have identified in OOTB Export feature ? mentioned by @pmahalle 

 

Reference 

https://docs.saviyntcloud.com/bundle/EIC-User-v24x/page/Content/06-mang-cert/cert-view-camp-smry.htm

https://docs.saviyntcloud.com/bundle/KBAs/page/Content/Queries-for-generating-campaign-reports.htm 


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

Hi @rushikeshvartak , Thanks for the response,

I have checked the links above, the information given provides the data of the status of the campaign w.r.t each certifier. However, we are looking for queries which provides the below data:

  • An SQL query for the analytics which will give us the summary for User manager certification employment verification (step 1) 

    For E.g.: When we run the analytics, the output should show us: Total users count, Users marked as “Works for me” in the campaign, Users marked as “Terminated” in the campaign, Users marked as “Does not work for me”, Users with no response.

  • An SQL query for the analytics which will give us the summary for User manager certification access verification (step 2)

    For E.g.: When we run the analytics the output should show us: Total access, Access certified, Access revoked, Access with no response.

Regards,

Naveen

 

 

Did you check this post : USER MANAGER CAMPAIGN - EXPLAINED - Saviynt Forums - 34852

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

Please share draft query prepared from you


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