Video Screencast Help

Managing the Software Catalog in SMP/CMS 7.1 -- Deleting Software Packages

Created: 19 Dec 2012 | 6 comments

After several unsuccessful attempts at creating Software Products and Releases in SMP 7.1, we finally have a combination of settings that will work in our environment.  It's now time to cleanup old packages/Products/Releases that we no longer want in the environment.  I am finding that deleting software entries whether it's thorugh the Catalog, Software Products or Software Releases is an elusive task.

When I delete an entry, the delete fails and I get a list of locations that the item is being referenced.  However, I cannot find the resource referenced in the list of conflicts.  I've spent the better part of two hours to try to delete just one software package from the environment with no luck.  I'm tempted to just delete all the source files from the Software Catalog UNC directory path -- hwoever that won't clean up the list of available software.  I have already dleeted all Tasks/Jobs/Policies that referenced the sepcific software product.  Now it's time to delete the entries from teh actual software list itself. 

Anyone have any insights - short of throwing a hand grenade at the server?

 

Comments 6 CommentsJump to latest comment

andykn101's picture

Try this:

"Unable to delete item due to dependencies"

http://www.symantec.com/docs/TECH147435

1. Delete all entries in ItemReference where the GUID of the object to be deleted is set the ParentItemGuid

2. Pass the GUID of the item into the following URL

http://localhost/Altiris/NS/Admin/Menu Items/DeleteItem.aspx?itemguid=<guid>

This should delete the item.

Authorised Symantec Consultant (ASC) with Endpoint Management Limited, an Authorised Symantec Delivery Provider based in the UK.

Connect Etiquette: Please "Mark as Solution" posts that fix your problem.

Papa-Gio's picture

That doesn't seem to be an option on SMP 7.1 SP2, with Server 2008 R2...

 

John A.

AngelD's picture

John,

 

The KB is refereing to the ItemReference table in the Symantec CMDB database and not in the console itself.

andykn101's picture

Open SQL Server Management Studio and run the following as a Query:

Use Symantec_CMDB

DELETE FROM ItemReference WHERE ParentItemGUID LIKE ‘guid’

 

Authorised Symantec Consultant (ASC) with Endpoint Management Limited, an Authorised Symantec Delivery Provider based in the UK.

Connect Etiquette: Please "Mark as Solution" posts that fix your problem.

Tim.Jing's picture

Is there a better way to handle this? Can you set the software to Un-managed?

andykn101's picture

I prefer to keep the database as uncluttered as possible, and having possibly duplicate managed and unmanaged software components (releases, updates or service packs) is asking for trouble.

Authorised Symantec Consultant (ASC) with Endpoint Management Limited, an Authorised Symantec Delivery Provider based in the UK.

Connect Etiquette: Please "Mark as Solution" posts that fix your problem.