Analytics query to get the summary of User Manager Campaign

[yeddulanaveen]

Hi,

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

Regards,

Naveen

[pmahalle]

@yeddulanaveen ,

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

OOTB report doesn't fulfill your requirement? 

[Raghu]

@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

[rushikeshvartak]

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 

[yeddulanaveen]

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

[Manu269]

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

[rushikeshvartak]

Please share draft query prepared from you