Password Expiration Notification for Orchestrator

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

1 Like

@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
latslogin

1 Like

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.

1 Like

@Rahul_Jakhmola14
You are talking about Enterprise Edition Right ?

1 Like

You’re talking about MY SQL Edition ?

1 Like

@Rahul_Jakhmola14
Nop , your Orchestrator License type , i hope you are not using cloud edition
this is taken form via accessing uipath Orchestrator DB

1 Like

We are using Oprem- Orchestrator.

1 Like

@Rahul_Jakhmola14
ok then go to your Orchestrator DB and create a new query using given sql code

1 Like

I need to do this using UiPath Workflow.

1 Like

@Rahul_Jakhmola14
sorry for the delay , I was returning to home after office :sweat_smile:
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

1 Like

Thank you so much Maneesha for sharing this xaml. Will do the same that you suggested. Thank you again :slight_smile:

1 Like

@Rahul_Jakhmola14
You are welcome and hope you got the solution

1 Like

Yes, the root i was looking for ,i found it. :slight_smile:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.