Click HERE to see how Saviynt Intelligence is transforming the industry. |
04/24/2024 01:54 AM
Hi Team,
While i export the campaign details i am able to see most of the values populated as per below sreenshot
But if i want to add some more user metadata like some other cp in the export report how to do this.
Thanks
Arnab Pal
04/24/2024 02:24 AM
@ARNAB86 you can write sql query and get report from analytic , include required columns
example:
select u.username from campaign cm inner join certification c on cm.id=c.campaignkey inner join certification_user_status cus on c. certkey=cus.certkey inner join certification_user cu on cus.cert_userkey= cu.cert_userkey inner join users u on cu.userkey=u.userkey where cus.certified is null and cm.campaign_name='<campaign_name>'
04/24/2024 02:36 AM
Can you please provide me the query to fetch the above details
Thanks
Arnab Pal
04/24/2024 03:07 AM
or u can add below config : required attribute it will come in export list
04/24/2024 05:25 AM
Its already in OOTB report export why do you need custom report ?
05/02/2024 02:24 AM - edited 05/02/2024 02:25 AM
But Client want it should be custom query so we can add some extra attributes in query itself to fetch the details instaed in OOTB export report functionality
05/02/2024 08:59 PM
When you are running export you can get query from logs
05/02/2024 03:32 AM
Did you checked following posts :
Campaign Report Queries - Saviynt Forums - 50171
Solved: Campaign Query Report - Saviynt Forums - 90168
Solved: UM Campaign Data - Analytics Report - Saviynt Forums - 54339
Frequently used Campaign Reports based on Campaign... - Saviynt Forums - 28534
How To - Create Frequently used Campaign/Certifica... - Saviynt Forums - 29145