Is there a utility that allows me to delete items based off of an item GUID?
Caution: Remember to back up your database, or have a recent backup available, as a preventative measure.
We used to have an utility that could be used to delete a specific GUID from the database. We don't recommend doing that anymore. It is better to use the current delete framework process.
1. You could use the following query and feed the proper GUID values to it:
--Change the item attribute
update Item
set Attributes = 0
where Guid = 'Guid here'
--find dependencies
select i.Name, i2.Name, ir.Hint, ir.* from ItemReference ir
left join Item i on i.Guid = ir.ParentItemGuid
left join Item i2 on i2.Guid = ir.ChildItemGuid
where ParentItemGuid = 'Guid here'
OR ChildItemGuid = 'Guid here'
--Delete references from ItemReference table
delete from ItemReference
where ParentItemGuid = 'Guid here'
or ChildItemGuid = 'Guid here'
--Insert item into ItemToDelete table and let the delete framework to remove any other reference
insert into
ItemToDelete (Guid, DeleteDate)
values ('Guid here', GETDATE ())
2. After the GUID(s) have been added to the ItemToDelete table, run the "NS.Quarter-Hour.{5834ae07-1160-4037-8a25-67aebf6a254e}" Scheduled Task under Task Scheduler.