Saviynt Forums

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 · 02/12/2024

Hello Experts,I have below JSON in snippet from CREATEACCOUNTJSON sap connection."LOGONDATA": {"USTYP": "A","GLTGV": "${java.time.LocalDateTime.now()}","GLTGB": "9999-12-31","CLASS ": "${if(user?.employeeType?.equalsIgnoreCase('External')) {'EXTERN'}...

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.

prasadpatil16 · 02/12/2024

This is bug. I tried with reducing the file contains and that worked and removing header line from data file. Attaching the working files.

prasadpatil16 · 01/21/2024

Please find logs

Online Status	Offline
Date Last Visited	‎03/28/2024 07:06 AM

Saviynt Forums

User Statistics

User Activity

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

SAP Provisioning failed

Re: Get report for daily user login

Re: Write account name to User CP

Re: Account Name Generation using CP

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

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

Re: Get report for daily user login

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