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

Certification Action

Nagateja_K
New Contributor II
New Contributor II

Hi Everyone ,

can whether certification is approved or revoked from any certification tables in saviynt ?
Basically I want to know what sort of action that is taken on certification.

Thanks in advance

3 REPLIES 3

naveenss
All-Star
All-Star

Hi @Nagateja_K can you please elaborate on the use case?

 

 

Regards,
Naveen Sakleshpur
If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.

Nagateja_K
New Contributor II
New Contributor II

can we know what is the action perfomed on certification from sql query whether its revoked or approved or partially revoked?

Refer https://forums.saviynt.com/t5/saviynt-knowledge-base/frequently-used-campaign-reports-based-on-campa... 

SELECT ce.certkey      AS 'Certification ID',
       c.campaign_name AS 'campaign name',
       CASE c.status
         WHEN 1 THEN 'In Progress'
         WHEN 2 THEN 'Completed'
         WHEN 5 THEN 'In Progress'
         WHEN 4 THEN 'Preview'
         WHEN 6 THEN 'Discontinued'
         WHEN 7 THEN 'Expired'
         WHEN 8 THEN 'Launching'
       END             AS 'Campaign Status',
       ce.cert_name    AS 'Certification Name',
       CASE
         WHEN ce.status = 0 THEN 'New'
         WHEN ce.status = 1 THEN 'In Progress'
         WHEN ce.status = 2 THEN 'Completed'
         WHEN ce.status = 3 THEN 'Locked'
         WHEN ce.status = 4 THEN 'Expired'
         WHEN ce.status = 7 THEN 'Discontinued'
         WHEN ce.status = 8 THEN 'Locked and Task Created'
         ELSE NULL
       END             AS 'Certification Status',
       u.displayname   AS 'Certifier Name',
       c.start_date    AS 'Campaign Start Date',
       c.end_date      AS 'Campaign End Date'
FROM   campaign c,
       certification ce,
       users u
WHERE  c.start_date >= Date_sub(Curdate(), interval 30 day)
       AND c.id = ce.campaignkey
       AND ce.certifier = u.userkey 

rushikeshvartak_0-1715914318254.png

https://forums.saviynt.com/t5/identity-governance/campaign-query-report/m-p/90353#M58685

 

 


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