Saviynt Forums

prasadpatil16 · 06/04/2024

Hello Experts,I have Security System - Applications Security System. Under this SS I have Endpoint Security Operator. Under the enpoint I have enterprise Roles XYZRole(Enterprise Role have entitelement from different endpoint). After assigning role t...

Get report for daily user login · 03/28/2024

Hello Experts,I want to develop analytic report for getting daily login details for user. I have below query just need help to filter this for todays date.select u.username,u.firstname,u.lastname,l.logintime, l.LOGOUTDATE from userlogins l,users u wh...

Write account name to User CP · 03/12/2024

Hello Experts,I have a concern to write the account name to User CP after account is provisioned to user.Do we have any option other then Sav For SavThanks,Prasad Patil

prasadpatil16 · 03/05/2024

Hello Experts,I need help in developing enhanced query for below senario,We have dataset with Department, country and Role. we want to update the XYZ app Accounts CP10 attribute based on camparing users Department and Country with Dataset Department,...

prasadpatil16 · 02/13/2024

Hello Experts,I have SAP application integrated with Saviynt and need to generate the unique account name. Below are the conditions1. Name John LunarI_LUNARJ2. User with same name John Lunar joins (As per the format I_LUNARJ it should validate and cr...

prasadpatil16 · 06/04/2024

That is requirement from Client considering the user usability.

prasadpatil16 · 06/04/2024

Yes. It is completed and assigned.

Re: Get report for daily user login · 03/28/2024

Below Query work for me select l.userkey,u.username,u.firstname,u.lastname,l.logintime, l.LOGOUTDATE from userlogins l,users u where l.userkey=u.userkey and l.userkey= 45 and date_format(l.logintime, '%Y-%m-%d') >= date_format(sysdate(), '%Y-%m-%d')

Re: Write account name to User CP · 03/12/2024

Yes correct.We need to save the username to CP64 of user as same name can be used for other accounts.

prasadpatil16 · 02/14/2024

Hello Rushikesh,Thanks for the assistance. But your query does this for 3 condition. What if there 5 users in same name. Also want to understand how will we check the duplicate account name.

Online Status	Offline
Date Last Visited	‎06/05/2024 12:00 AM

Saviynt Forums

User Statistics

User Activity

Assigned Enterprise role are requestable

Get report for daily user login

Write account name to User CP

Enhanced Query for JOB to Update Account CP based on dataset value

Account Name Generation using CP

Re: Assigned Enterprise role are requestable

Re: Assigned Enterprise role are requestable

Re: Get report for daily user login

Re: Write account name to User CP

Re: Account Name Generation using CP

Re: Get report for daily user login

Re: Error Data File Not found for any Schema File ...