After adding Software to a Managed Delivery Policy, you can specify a specific user in advanced settings to run the installation under. If an account used here needs to have a password updated, or the account changed due to having the account disabled, here is a way to identify those accounts.
The following SQL will provide a list of Policy names to edit as needed.
Insert the username that requires a password edit or requires change where indicated:
select DISTINCT Policy.name from itemversiondata ivd join ItemVersions iv on iv.VersionGuid = ivd.VersionGuid join item task on task.Guid = iv.ItemGuid join ItemReference ir on ir.ChildItemGuid = task.Guid join item Policy on Policy.guid = ir.ParentItemGuid where ivd.State like '%<username>admin</username>%'
Subscribing will provide email updates when this Article is updated. Login is required.