Hi Everyone,
How to get the information of user’s that when they last change their password or when their password will get Expire? Anyway to achieve this ?
Regards,
Rahul
Hi Everyone,
How to get the information of user’s that when they last change their password or when their password will get Expire? Anyway to achieve this ?
Regards,
Rahul
@Rahul_Jakhmola14
Welcome to Uipath community
Use follows on your Orchestrator DB
SELECT *
FROM [YourDB].[dbo].[Users]
YourDB = make your orchestrator DB name
You will see of your required data on this table as below
Thanks for replying Maneesha. It would be very helpful if you can share share the workflow ,how would i connect with Orchestrator and apply this Query.
@Rahul_Jakhmola14
You are talking about Enterprise Edition Right ?
You’re talking about MY SQL Edition ?
@Rahul_Jakhmola14
Nop , your Orchestrator License type , i hope you are not using cloud edition
this is taken form via accessing uipath Orchestrator DB
We are using Oprem- Orchestrator.
@Rahul_Jakhmola14
ok then go to your Orchestrator DB and create a new query using given sql code
I need to do this using UiPath Workflow.
@Rahul_Jakhmola14
sorry for the delay , I was returning to home after office
Main.xaml (5.3 KB)
I have added Message box to gather and show you the data , you can and any development to view into it by replacing message box
and create the database link on “Connect” activity to your Orchestrator DB
Thank you so much Maneesha for sharing this xaml. Will do the same that you suggested. Thank you again
@Rahul_Jakhmola14
You are welcome and hope you got the solution
Yes, the root i was looking for ,i found it.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.