How to insert multiple user records for the same user in Data Base from Saviynt

[Siva]

Hi Experts,

We have a requirement with database in which we have a single table, Is it possible to create multiple entries for the same user with multiple groups from Saviynt?

Thanks
Siva

[rushikeshvartak]

yes its possible https://www.mysqltutorial.org/mysql-insert-ignore/

INSERT INTO subscribers(email) VALUES('john.doe@gmail.com'), ('jane.smith@ibm.com');

[Siva]

Hi Rushikesh,
Thanks for helping, I will try with this. 

Regards,
Shiva

[Siva]

Hi Rushikesh,

We have a requirement in which we have to insert the data into database on a daily basis. 
I have to insert the various data for same existing user in the database on daily basis.

Could you pls tell,Is it possible to insert multiple rows into database for same user's account?

Thanks
Siva

[rushikeshvartak]

If its target application and application allows its possible but what will be trigger point ? You will create update accoun task via actionable report / rules and write query in side update account json

[Siva]

Hi Rushikesh,

Thanks for the above info, but we are sending data to temporary table from there it goes to main application table but the thing they are deleting the data on daily basis (if i send a user data today to the temporary table then they will delete that data). 

Here we need to insert the new records into the table on a daily basis from saviynt. we are able to create an account and insert data into the table for once.

Could you pls tell me, is it possible to insert all user's data on a daily basis without creating an account?

Thanks
Siva

[rushikeshvartak]

You can do it create dummy update account tasks . Under Update account task write your logic.

This is not the best practices just workaround

[Siva]

Hi Rushikesh,

Thanks for the suggestion.
Could you please tell me, do we have any function other than order by to order the newly add entries at top in MySQL?
Even, we have tried with order by function, but it's not making that order. 

Thanks
Shiva

[rushikeshvartak]

sort basis on updatedate if you have column. 

[KhaoulaD]

Hello,

You can use this SQL query to get all the latestes identities pushed into the platform by order as following:

select userkey, username, email from users order by userkey DESC

Regards,

Khaoula DOUHI

[Siva]

we don't have updatedate, createdate only passing in this report.

Thanks,
Siva

[rushikeshvartak]

if you can share query i can try 

[Siva]

select Createdate,Username, 
CASE WHEN customproperty3 = 89 THEN 'AITS'
WHEN customproperty3 = 65 THEN 'AMS' 
ELSE STATUSKEY END 'CompanyName', Firstname,Lastname,Displayname, customproperty1 as SamAccountName, CASE WHEN STATUSKEY = 0 THEN 'INACTIVE' WHEN STATUSKEY = 1 THEN 'ACTIVE' ELSE STATUSKEY END 'UserStatus' from users WHERE ((firstname LIKE '% %') OR (lastname LIKE '% %') OR (firstname LIKE '%-%') OR (lastname LIKE'%-%')) and date_sub(sysdate(), INTERVAL 7 DAY) < Createdate order by Createdate DESC

[rushikeshvartak]

Its not showing record only in saviynt ? did u checked from data analyzer. I feel analytics sort first column asc by default

[Siva]

Hi Rushikesh,

I have checked in the data analyzer; it's resulting sort of first column asc only even if I made it Order by createdate DESC.

Thanks
Siva

[rushikeshvartak]

What is significance of this making order by just to make sure data added in sequence?

[Siva]

They want see the latest user at the top in that analytic report,
So that they can check that user on priority

Thanks,
Siva

[RakeshMG]

Hi @Siva 

Please try, by this you will get the latest users.

select userkey from users order by userkey DESC