Identifying what Managed Delivery Policies use a specified user account
book
Article ID: 172341
calendar_today
Updated On:
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>%'