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
Article ID: 172341
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:
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>%'
Feedback
Yes
No
Powered by
