ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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