Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/23/2024 10:41 AM
Hello All,
I want to create a report for application owner campaign having
1) Campaign Name
2) Consultee
Such that the step2 consulted is done but there is no response.
Kindly guide me as I am not aware of which table the actions get logged like consult and no response. we are using EIC v24.4
Thank you
Mahesh
05/23/2024 11:02 AM
SELECT
a.CERT_NAME 'CERTIFICATION NAME',
CASE
WHEN a.status = 0 THEN 'New'
WHEN a.status = 1 THEN 'In Progress'
WHEN a.status = 2 THEN 'Ready to Submit'
WHEN a.status = 3 THEN 'Submitted'
WHEN a.status = 4 THEN 'Expired'
WHEN a.status = 5 THEN 'Discontinued'
WHEN a.status = 6 THEN 'Preview'
WHEN a.status = 7 THEN 'Discontinued'
WHEN a.status = 8 THEN 'Submitted and Task Created'
WHEN a.status = 9 THEN 'Cancelled'
WHEN a.status = 10 THEN 'Submitted'
END 'CERTIFICATION STATUS',
DATE(a.startdate) 'CERTIFICATION LAUNCH DATE',
CASE
WHEN (a.status IN (3 , 2, 8, 10)) THEN DATE(a.updatedate)
END 'CERTIFICATION COMPLETE DATE',
u.username 'CERTIFIER',
concat(u.firstname, ' ', u.lastname) AS 'CERTIFIER FULL NAME',
u.EMAIL AS 'CERTIFIER EMAIL'
from certification a, users u
where u.userkey = a.certifier
and a.type=9;
05/24/2024 01:11 PM - edited 05/24/2024 01:12 PM
Hi @rushikeshvartak ,
sorry looks like I did not explain well, actually I need to make a report for application owner campaign and that should list all consulted line items which has no response.
I made following query but still the consulted usernames coming wrong and the number of data shown is wrong so, you can comment may be , you may have some insight.
05/26/2024 09:24 AM
What if multiple consultee ?
05/29/2024 06:29 AM
One is user for which the consult is done, another is the new user who is consultee, who will be new certifier(approver/ rejector of access).
Thanks
Mahesh
05/29/2024 11:09 PM
Can you explain with example