Software Delivery Bulk Password Change (NS6)

Our password policy states that all passwords must be changed on some regular basis.  We use two particular accounts for software delivery so there are lots of entries for those users.  I found directions for updating passwords in Deployment Server but not for NS so I wanted to share.  I tried to figure out what hash was being used, since that would alleviate the need to change the password in a software program and then look it up, but the hash is non-standard.

The first step is to open a software delivery package.  From there go to the Programs tab, set the new password for the user, and save the changes.  Use the query below to return the new hashed password.  The query also returns some basic software information to make sure you are looking at the correct program.  If there are multiple programs to a package you want the one package with the different password than the others.

select swdpackage.name as [Package Name], swdprogram.name as [Program Name], CommandLine, [User Name], [User Domain], Password
from swdprogram
join swdpackage
on swdpackage.packageid = swdprogram.packageid
where password != ''
and swdpackage.name = 'insert package name here'

Once you are satisfied that you have the correct password from the correct package run the query below to update the password for that user for all programs.

update swdprogram
set password = (
select password
from swdprogram
join swdpackage
on swdpackage.packageid = swdprogram.packageid
where password != ''
and swdpackage.name = 'insert page name here' -- should be the same as the package name above
and swdprogram.name = 'insert program name here'
)
where [user name] = 'insert username here'

This can be repeated as required for other user credentials.