Video Screencast Help
As we strive to continually improve your experience on our site, please help us by taking this survey and tell us about your satisfaction level using Symantec Connect. One lucky winner will receive 500 Connect points! * Take the survey.

DS 7.1.x display Usernames and hashed Passwords that Tasks are set to RunAs

Created: 27 Jun 2013 • Updated: 27 Jun 2013
jasoncordell's picture
0 0 Votes
Login to vote

Since we left DS 6.9, there is no mechanism to identify which usernames/passwords various tasks are set to run as.  I have a current need to transition to a new set of accounts for deploying DS 7.1.x Tasks, but I had no way of knowing how many accounts needed to be touched to complete the transition, so this SQL was written. 

This is laid out in a straight forward manner will a lot of documentation within the script.  You can easily modify this script to look for specific account(s), or even specific password hashes.

This SQL script requires 4 StoredProcedures and a Function to work properly and I have attached Create scripts for each of them.  This takes less than 10 seconds to bring back just under a thousand records.

Step 1:  Create spGetUsernameEmbeddedInTask
Step 2:  Create spGetUsernameEmbeddedInTask2
Step 3:  Create spGetPasswordEmbeddedInTask
Step 4:  Create spGetPasswordEmbeddedInTask2
Step 5:  Create fnSplit
Step 6:  Run ShowAccountForTaskRunAs

Hopefully someone finds this useful since some of the DS6.9 tools never made it over to 7.1.x.