Identifying what Managed Delivery Policies use a specified user account

Products

• Software Management Solution

Resolution

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>%'