6f735ab9-9cc3-4468-9dc5-bba90d175fff.jpg

Solution Architect

This snippet will be useful when we are trying to use UserID in our process and we need to check whether it is expired or not.

In some cases the BOTID, application login UserID or any other UserID related to the same domain might expire and in that case the process will fail.

Instead of running with this error, we can check those UserID's password expiry days and send a notification mail to the appropriate group/user to update the password. When the UserID is set with the option for the password to not expire, then this snippet is not required.

Note: For this snippet we need Windows admin access, since the process checks the data from the Active Directory System.

  

  

_Note:_ The functionalities are offered to allow robots to interact directly with existing business processes. They are not designed to provide new information security paradigms, but instead a means to allow the robot to interact with the existing security that is being deployed within a business.

This snippet will be helpful when we want to know the Excel column name for a given number, whenever we are writing some datatable into Excel with few columns, but not sure how many columns it occupies in the Excel. In that case we can pass that datatable column count number into this workflow and we can get the Excel Column Name.

Ex: If we are passing 10 as the column number it will return J as the column name.

If we are passing 28 then we will get “AB” as the output from this workflow.

This snippet will convert the passed inputs to Excel column name and row number

About me