Password Expiration Notification for Orchestrator

Help Orchestrator
1

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
2

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

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
4

@Rahul_Jakhmola14
You are talking about Enterprise Edition Right ?

1 Like
5

You’re talking about MY SQL Edition ?

1 Like
6

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

We are using Oprem- Orchestrator.

1 Like
8

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

1 Like
9

I need to do this using UiPath Workflow.

1 Like
10

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

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

1 Like
12

@Rahul_Jakhmola14
You are welcome and hope you got the solution

1 Like
13

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

1 Like
14

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