Jump to content
Leo

Password Field in Automate

Recommended Posts

Hi All,

Is there anyways to use the username/password field in Automate for scripts, I have seen in the past you can do a SQL Queue, but checking this we have the password encrypted, is there away around this? 

I know we could create a EDF field to complete this, but as the username and password is already there we would like to try and use it the field above. 

Thanks,

Share this post


Link to post
Share on other sites

This SQL Query:

SELECT CONVERT(AES_DECRYPT(PASSWORD,SHA(' @KeyValue@')) USING utf8) FROM Passwords WHERE clientid = %clientid% AND Title = 'Updated Local Admin'

Will retrieve a stored, encrypted password for you.  I use it in an automated script for getting a uniform local admin account on a client, but each client has a different password.  in the script, it looks like this:
image.png.6ab17eeffce194e4968c6635d8193f36.png
Hope this was helpful.

Share this post


Link to post
Share on other sites

Sorry for the Late reply, I have tried this but we are still getting null passwords, but thank you

This is the location we are trying to pull the password from: 

image.png.6933886ae99f280f19e7ab180e0864d2.png

Thank you

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...