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.