Clean up PCT Personalities while in the deployment phase

Products

• Client Management Suite
• IT Management Suite

Issue/Introduction

When capturing PCT personalities the list is growing long - is there a way to clean these up every day?

Environment

ITMS 8.x

Resolution

Use some text string in the name of your PCT Captures:

Then use this SQL query that moves anything with the PCT-Capture name into the ItemToDelete Table.  You could run this as a SQL Server Task on the SMP at 5:58pm each night to remove the day’s PCT captures.

NOTE: The ItemToDelete table is cleared out on the NS.Quarter-hour schedule

--Insert item into ItemToDelete table and let the delete framework remove any other references
insert into
ItemToDelete (Guid, DeleteDate)
select guid, getdate()
from vItem 
where name like 'PCT-Capture%'

This will delete the Package and PCT item in Image Management, which starts the countdown for the Package to be removed off the package servers as well.

It will be necessary to chose the correct PCT on the Deployment task due to this change.